Show all data -- FMR

[Guest]

I have 4 tables, each shares Date and Service, but after that they vary from
budget details, to capacity details, all the way to actual details. Since
the budget details go out into the future and the actuals do not, I want to
produce a worksheet showing data from all tables from a date and out to a
specified date. I know how to do the date request but the only data I get
from my query is what is populated in all tables. (linked on Service and Date)

Any assistance would be appreciated:

EX:

Date Forcast Budget Actual
1/1/07 25 26 30
1/2/07 24 26
20
1/3/07 25 25
1/4/07 25 25

 

[George Nicholson]

Consider a UNION query of your 4 tables, making sure each record contains a
"SourceType" label of "Actual", "Budget", "Forecast", etc.

Then perhaps you can base a crosstab off of that UNION using SourceType for
a Column Header, etc.

"Quasi-parallel" (my own word, don't google it) data like
Actual/Budget/Forecast can be a huge pain to deal with, but I believe a
UNION query is the only real starting point. Someone else may chime in with
a different approach.

HTH,