Report Weekly Data - need help with setup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a Excel document that I need to convert into a Access report but am
not sure how to go about doing it. Here is how my Excel doc. is set up (I'll
use made up data so you can easily follow me.)

Excell Spreashee
--------------------------------------------------------------------------------------
Sales in Number of Fruit per Store

Mon. Tues. Wed. Thurs.
Fri. Total
Owner1 Store1 Oranges 10 15 3 2 5
26
Apples 5 10 5
1 2 23
Owner2 Store2 Oranges 6 4 3 7 2
22
Apples 15 6 4
5 9 39

Total By Day 36 35 15 15
18 110

-------------------------------------------------------------------------------------------

So... Thats my spreadsheet; Any help would be greatly appreciated.

Thanks!!!,
Chris C.
 
Sorry, in my first post, I noticed that my table got jumbled around.

Here it is a little clearer.

Excell Spreadsheet
----------------------------------------------------------------------------
Sales in Number of Fruit Per Store

M T W T F Total
Owner1 Store1 Oranges 10 15 3 2 5 26
Apples 5 10 5 1 2 23
Owner2 Store2 Oranges 6 4 3 7 2 22
Apples 15 6 4 5 9 39

Total By Day 36 35 15 15 18 110
 
You need to create a crosstab query and use it for the recordsource of your
report. Set the rows to Owner, Store and Fruit and the columns to
day-of-the-week.
 
Back
Top