B
brz
I have been going about this many different ways. I think this might be the
best so far. I have a query that has these fields.
[production_date],[employee],[truck],[load_size] and [rank]. Rank is a
count number from another query that counts the load_size field for each
employee on a given date. So there may be 1 to many records with the same
date same employee with a load_size that has a rank of 1,2,3,4….most likely
never more that 14. I want a report that groups by production_date by day
then has a detail showing all records for employee, truck, then load_size(1)
load_size(2) load_size(3)….up to as many as 14 but could be only 1. And will
be different for each employee on each day. I can make a cross tab query but
the problem would still arise with a variable number of load_size field for
each employee. The question is can the detail of the report pick up the 1
or up to 14 load_size fields for each detail and put them in a different
column on the report.
Again thank you all for your support and answers.
bob
best so far. I have a query that has these fields.
[production_date],[employee],[truck],[load_size] and [rank]. Rank is a
count number from another query that counts the load_size field for each
employee on a given date. So there may be 1 to many records with the same
date same employee with a load_size that has a rank of 1,2,3,4….most likely
never more that 14. I want a report that groups by production_date by day
then has a detail showing all records for employee, truck, then load_size(1)
load_size(2) load_size(3)….up to as many as 14 but could be only 1. And will
be different for each employee on each day. I can make a cross tab query but
the problem would still arise with a variable number of load_size field for
each employee. The question is can the detail of the report pick up the 1
or up to 14 load_size fields for each detail and put them in a different
column on the report.
Again thank you all for your support and answers.
bob