Microsoft Visual Basic Run-Time Error "2471": Unknown

Microsoft Visual Basic Run-Time Error "2471": Unknown

am 18.04.2008 15:48:11 von jmarr02s

I am trying to run a report, but I get the Microsoft Visual Basic Run-
Time Error '2471': Unknown

I googled the error and found that the Run-Time Error 2471 points to
an "Item in query".

Here is the code for my query for this report:

SELECT [qry IBCCP ReferralsRpt2Every10thNoQANoCallDate].*, [Copy of
Test].QualityAssuarnce, [Copy of Test].CallDate
FROM [qry IBCCP ReferralsRpt2Every10thNoQANoCallDate] INNER JOIN [Copy
of Test] ON [qry IBCCP ReferralsRpt2Every10thNoQANoCallDate].[Caller
ID] = [Copy of Test].[Caller ID]
WITH OWNERACCESS OPTION;

Any ideas?

Many Thanks and Happy Friday :)

John

Re: Microsoft Visual Basic Run-Time Error "2471": Unknown

am 18.04.2008 23:00:49 von Rich P

Try running the query by itself and see what happens. If the query runs
without any problems then create a new report based on this query and
add the field list to the report and run this new report - don't use
parameters for starting. If this new report runs without problems, then
if you are using parameters - add the parameters to your query and see
how that works. If the new report has problems now - then the problem
would be with the parameters - if you are using parameters.

Rich

*** Sent via Developersdex http://www.developersdex.com ***