ACCESS prompts for index number upon running a report

jasminewhite

Registered User.
Local time
Today, 13:58
Joined
Dec 8, 2011
Messages
26
I created a report based on a query, when I run the report, Access prompts to enter [table-name].index number. I just press the OK button, the report runs fine. Why does it do this? How do I fix this?
I am asking for help from all the Access experts out there. This is the 1st time I work with Access 2007.
Thanks in advance,
Jasmine :confused:
 
Does that field exist in the record source of your report?
 
yes, index number is a field in my table
 
Copy and paste the SQL statement of the query here. You can get it by going into SQL View.

Then tell me exactly what the prompt says.
 

Users who are viewing this thread

Back
Top Bottom