select query criteria

[dott]

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?

 

[jtvcs]

Just a suggestion but have you tried running a Query on the Query Results ?? In other words can you use a query to limit to Project No then use its results in a subsequent query to maintain the grouping you desire ? HTH JT

 

[AncientOne]

can you post the SQL for the Query, please?