Query after Filter by Selection

[rob c]

I am working on a query where the enduser needs to be able to see the total
value on the query and to have the total change any time a "filter by
selection" is performed.

I set up one query that I'll call "first query" directly from a table. I
also set up a query that I'll call "second query" based on the results of
"first query". I used Sum and get the same total regardless of what I
filter out using "filter by selection".

I have also tried to put the query onto a form, but get a message that there
are too many fields in the first query.

Can you tell me either what I need to do in order to get a total that
changes on "second query" or some other way that I can accomplish the same
thing using a different method.

Regards,

Rob