G
Guest
I must be missing something. I'm tracking "Sales" numbers for three
restaurants that each have a "lunch" shift and a "dinner" shift. The
database I have created is simple, with two tables. One table is simply a
look-up for store locations, the other table has all the "sales" data (by
shift) in it. My query works in as much as it returns all the data correctly.
My problem is my report. I would like the report to return the sales data
by shift ("Lunch" & "Dinner"), which it currently does in two columns. BUT,
what I can't seem to resolve is, how I can add a third column that will total
each "department" for the entire day (both "shifts", same "date"). I have
tried several approaches, and think that it is probably something simple that
I am skipping over. The results I get from a SUB report based on a SUM query
returns sums for each shift (which basically makes it a duplicate column of
the same information) I'm stumped.
Suggestions appreciated. What a great forum ! . . . Dave
restaurants that each have a "lunch" shift and a "dinner" shift. The
database I have created is simple, with two tables. One table is simply a
look-up for store locations, the other table has all the "sales" data (by
shift) in it. My query works in as much as it returns all the data correctly.
My problem is my report. I would like the report to return the sales data
by shift ("Lunch" & "Dinner"), which it currently does in two columns. BUT,
what I can't seem to resolve is, how I can add a third column that will total
each "department" for the entire day (both "shifts", same "date"). I have
tried several approaches, and think that it is probably something simple that
I am skipping over. The results I get from a SUB report based on a SUM query
returns sums for each shift (which basically makes it a duplicate column of
the same information) I'm stumped.
Suggestions appreciated. What a great forum ! . . . Dave