Make report based on the fields from a query

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

I have a query that has 12 fields/columns. 8 of the columns are 4 sets of
two (hrs to date and hrs for this month four times each - because there are
four office branches).
I need to make a four page report that shows 2 out of the 8 columns, per
page. All 4 pages will have 2 of the 3 remaining columns (JobTitle and
TotalHrs for that JobTitle).

Any ideas?
 
Jacques,

I am not sure how you arrived at a query with 12 columns, but I think you
would be better off creating a union query that brings together in 6 columns
all of the data for the four branches.

Then on the report you can place the 'branch' info in the page header. Sort
by branch and set the 'keep together' to yes and place all your other branch
specific data in the detail section. In the detail section, set the 'Force
new Page' property to 'After Section'.

HTH

Greg
 
Column headers in the query (I will happily change my query if that will
produce the solution, but the report must look a certain way).
1) Company
2) JobTitle
3) Office1-TotalToDate
4) Office1-TotalForTheMonth
5) Office2-TotalToDate
6) Office2-TotalForTheMonth
7) Office3-TotalToDate
8) Office3-TotalForTheMonth
9) Office4-TotalToDate
10) Office4-TotalForTheMonth
11) AllOfficeTotalToDate
12) AllOfficeTotalForTheMonth

Every column has seperate info.
Once I can get this on a report, I'll be creating text boxes that do the
percentages.
The Company will only be in the report header and a report is only generated
per company.
The amount of records on the report is dictated by the amount of job titles
pulled in the query.
 
Back
Top