Query Help

[gkaro]

Hi, Im new at this so please forgive my simple question.

I Have a table

Budget (1=actual 2=Target)
Retailer
YR (Year)
Sales#

I would like to create a query that outputs the following 6 colums

YR / Retailer / SumActual Sales / SumTarget Sales / Variance(Actual-Budget) / Variance%(Actual/Target-1)

I cant seem to get this to work.


thanks for your help

[June7]

Try 3 queries:

First query selects only the actual budget records.

Second query selects only the target budget records.

Third query joins the first two on the year and retailer fields. Use this query as the source for calculations. Or better, use it as RecordSource for a report and use the report's Grouping & Sorting with aggregate calcs functionality.

Assumes the budget/retailer records will be in pairs.