#name? Error

O

OKBilly

I inherited this Access Document and I am by no means an Access expert. The
document was created in Access 97, and we use Access 2002 from Office XP.

The problem is with running one of the reports. When you run the report it
asks for "date" and "who" and "which dept" then it runs the report when it
works right.

When it works wrong it puts this "#name?" in the dat spot then even if you
delete that and put in a date it says "Cannot have aggregate function in
ORDER BY clause (Count([ID]). then it closes the report altogether.

Also I noticed that in the table it it says #name? in the Next date feild
record you will try to enter in.

Anyone have any ideas?
 
C

Compuhelpmt

Sounds like your problem resides in the query the the report is running
from. There are fields or a sorting and grouping setting that are not
getting the data they need to print out in your report. When the report is
open in design view, Right click the fields that show #name to see where
they are trying to get information from. That will be a clue.
 
Top