I have a report that is based on a query. One of the fields returned by the query is projectID. When I try to add that field to my report with "add existing fields", projectID does not show up in the list. Any ideas why or how I can get the field added?
Can't find field
- Thread starter ajarrell
- Start date
Isskint
Slowly Developing
- Local time
- Today, 06:52
- Joined
- Apr 25, 2012
- Messages
- 1,302
The only reason i can figure for a field to not show up in the existing fields list, is if the field in the query is not selected for display. Check the field has the little tick under it in the query. Have you saved it?
Next check the report recordsource is the query you expect.
If the field is available to the report you should be able to bypass by placing a control on the report and setting the recordsource to projectID.
LOL yeah save it first
Next check the report recordsource is the query you expect.
If the field is available to the report you should be able to bypass by placing a control on the report and setting the recordsource to projectID.
LOL yeah save it first
Similar threads
