By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ***
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.