i have a simple select query which is the basis for a report...
when i go to open the report, i wish to specify a field (project no)in the where clause that is not a field in the query, but is in the underlying tables of the query
the reason why i cant add the field to the query is because if i do it groups the records wrong and screws up my results, but i do wish to limit the records shown based on this field
if i hard code in the criteria for 'project no' in the query itself and uncheck the 'show' box in query design view it works fine, so it seems like there should be some way i can get this to work
anyone have any thoughts on this?
when i go to open the report, i wish to specify a field (project no)in the where clause that is not a field in the query, but is in the underlying tables of the query
the reason why i cant add the field to the query is because if i do it groups the records wrong and screws up my results, but i do wish to limit the records shown based on this field
if i hard code in the criteria for 'project no' in the query itself and uncheck the 'show' box in query design view it works fine, so it seems like there should be some way i can get this to work
anyone have any thoughts on this?
Last edited:
