Re: Report Weekly Data - need help with setup

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.

--
PC Data***
Your Resource For Help With Access, Excel And Word Applications
resource@xxxxxxxxxxxxxxx
www.pcdata***.com


"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:05A47672-27C8-4281-84B1-D89922F61882@xxxxxxxxxxxxxxxx
> 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 Sprea***
> --------------------------------------------------------------------------------------
> 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 spread***; Any help would be greatly appreciated.
>
> Thanks!!!,
> Chris C.


.