How to make a report from nothing

[Jacques]

I have to make a report that shows the amount of hrs worked per JobTitle per
OfficeBranch.
I learned earlier through the newsgroup how to make a cartesian query so I
can show all the OfficeBranches when someone didn't work at a branch, but
now I have to make a report that does two things

1) Shows two columns
The first has all hrs to date
The second only shows hrs for a given month

2) Every OfficeBranch and every JobTitle must show up even if no hrs were
worked by that job title.

I would just use a CrossTab query (because there are only 4 OfficeBranches
but dozens of JobTitles) but the report HAS to be broken in an OfficeBranch
per page.

My problem is I can't get more than one outer join (if I'm saying this
right) in a query that says "all of these records and only those that match"
and there's no such thing as "show all records from both sources even when
they don't match"

Thank you beforehand

 

[[MVP] S.Clark]

Make two seperate queries, and fuse them together into one table.

So, pre-create the dest table, then make two append queries to do the rest.