I suspect I'm making this more difficult than it is but I've been struggling all weekend and I still haven't gotten it to work.
I want to produce a report with 12 columns as follows:
This data will be entered by account number within departments.
The fields in the data table are: account number, department, week number, actual or budget (yes/no) field, and the amount. I also have a table that translates the weeks into the appropriate month and quarter. How do I build the queries to get all the above columns on a single report? Or do I need to structure the input tables differently? I would so appreciate your help!