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

[zufie]

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 ReferralsRpt2Ev ery10thNoQANoCa llDate].*, [Copy of
Test].QualityAssuarn ce, [Copy of Test].CallDate
FROM [qry IBCCP ReferralsRpt2Ev ery10thNoQANoCa llDate] INNER JOIN [Copy
of Test] ON [qry IBCCP ReferralsRpt2Ev ery10thNoQANoCa llDate].[Caller
ID] = [Copy of Test].[Caller ID]
WITH OWNERACCESS OPTION;

Any ideas?

Many Thanks and Happy Friday :)

John

[Rich P]

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

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 ***