MS Access 2007 SQL with WHERE and GROUP BY does not use FILTER properly -

MS Access 2007 SQL with WHERE and GROUP BY does not use FILTER properly -

i have query looks sql:

select a,b,c tablea d = "something" grouping a,b,c

the query works fine.

when utilize query in report, works fine.

if seek apply filter like

d="something" , e="whatever"

to record source study in report's onactivate event, prompts value "e" , not select anything, if come in "whatever" @ prompt "e".

my understanding "filter" clause of query, appear in case of totals query (i.e. containing grouping clause), more having clause. what's going on? there way around it?

to reply sec question, got around building entire select statement in report's onopen event , used set recordsource. however, still understand how filter works when there's grouping clause in select statement.

the filter property of study sees end result of query, not base of operations table(s) of it. while can utilize column d in clause within query (or of columns of base of operations table, matter), not projected select statement, can't refer columns d or e on study filter. honest, i'm not sure can want here this, impact pre-aggreation criteria in query.

sql group-by ms-access-2007 group where-clause