I have a report that is based on a query. It works fine but I am puzzled as to the existence of a field in the field list selector. it is called Expr 1004 and does not appear in the underlying query and when i select it to be displayed on the report it brings thru the primary key field for a related table - which is in the underlying query but is not in the report (it is a lookup field that would only display the number rather than the actual word)
Expr 1004
- Thread starter emcf
- Start date
Ally
Registered User.
- Local time
- Today, 01:54
- Joined
- Sep 18, 2001
- Messages
- 617
When Expr.... appears on your queries, it means that a field has been repeated. Sometimes you may need to enter a field more than once, for sorting purposes, but you should then uncheck the Show tickbox so that it doesn't appear.
If your primary key field is appearing, that would suggest that's the field that's been entered twice, so in design view of your query, look for the second occurance of that field and delete it from the query or uncheck the tickbox if you do need it.
If your primary key field is appearing, that would suggest that's the field that's been entered twice, so in design view of your query, look for the second occurance of that field and delete it from the query or uncheck the tickbox if you do need it.
Similar threads
