Combining CrossTab Qry

[Pedro]

Hello everyone,
I have 4 tables : budget, sales, buyings and other expenses. They all have
two fields in common : name of the restaurant and the type of expenses. I
would like to build a report that shows me, by type of expenses and then by
restaurant, the budget and the real values for each type and restaurant, by
month.
For that i've build 4 cross tab querys, based on 4 normal qry's. I've try
several kinds of assossiation properties between them all and still not
working. One way or another it doubles the records of some qry when i run it.
I'm kinda stuck here and i would apreciate any fast help before my head
explodes. (lol)
tks a lot
Pedro

 

[Golfinray]

I would use the original tables the crosstabs are based on to build the form
or report. As a rule, crosstabs are not editable (don't have the arrow and
asterisk at the bottom) are are going to be a headache. Be sure you go into
tools/relationships and set the relationships on the tables first.