Query criteria range in values 1

[TheBlade]

Hi

I have 2 tables:
1. GL account (which shows GL account number, name and account type etc.), and
2. GL Entry (values posted to GL accounts).

GL accounts in GL account table with an account type of 4 are totalling accounts. I created a query which shows the range of accounts they should total, e.g. GL account number 1199 (Total Product Revenue) should be totalling 1100 to 1198 (so query shows fields - 'GL account', 'From' and 'To'...'From' and 'To' will be the same number for non-totalling accounts).

Is there a quick way of doing this in one query? (rather than doing a query for each, as there are 46 totalling accounts, and they may change from time to time).

thanks
Vince

 

[LittleBob]

Use a totals query.
Start with a new query in design view,
View, totals.

In the Acount Id column but the
"group by" criteria.

Under sales.
"sum"
And so forth.

Hth
LittleBob