Perhaps I don't understand your issue.

Assuming you've got a table along the lines of:

Category
MeaurementDate
Measurement

you'd select Category as the Row heading (on the 2nd page of the wizard),
MeasurementDate as the Column heading (on the 3rd page of the wizard), then
Measurement on the 4th page of the wizard. Since you've only got one value
to calculate, you can use Avg, First, Last, Max, Min or Sum as the function.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Adam@nospam.com" wrote in message
news:1150120880.150823.269720@h76g2000cwa.googlegr oups.com...
> Thats what I need but how do i do more than 2 categories??
>
>
>
> Douglas J Steele wrote:
>
> > What I understand is that you wanted months across the top, and 20
different
> > categories along the left. At the intersection of each category and each
> > month, you want a value that will represent the measure for that
category
> > for that month.
> >
> > That's a cross-tab query...
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> > "Adam@nospam.com" wrote in message
> > news:1150118416.326584.230600@j55g2000cwa.googlegr oups.com...
> > > Hi Doug,
> > >
> > > Well there's around 20 fields that I'd like to line up on the left,
> > > however a crosstab query, as far as I know, only lets you look at a
> > > maximum of 2.
> > >
> > >
> > >
> > > Douglas J Steele wrote:
> > >
> > > > Based on your original post, it certainly sounds as though a
cross-tab
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11242-report-left-right-not-top-bottom.html
> > query
> > > > should fit the bill.
> > > >
> > > > What did you leave out of that original post?
> > > >
> > > > --
> > > > Doug Steele, Microsoft Access MVP
> > > > http://I.Am/DougSteele
> > > > (no e-mails, please!)
> > > >
> > > >
> > > > "Adam@nospam.com" wrote in message
> > > > news:1150116370.199385.39530@j55g2000cwa.googlegro ups.com...
> > > > > The crosstab wouldn't be sufficient though, as I have around 20
fields
> > > > > I want to include on the page.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11242
> > > > >
> > > > >
> > > > > Kernow Girl wrote:
> > > > >
> > > > > > Hi Adam - it sounds like what you want is a Cross-Tab Query. The
> > Help
> > > > screen
> > > > > > says this:
> > > > > > You use crosstab queries to calculate and restructure data for
> > easier
> > > > > > analysis of your data. Crosstab queries calculate a sum,
average,
> > count,
> > > > or
> > > > > > other type of total for data that is grouped by two types of
> > > > information -
> > > > > > one down the left side of the datasheet and another across the
top.
> > > > > > HTH - Dika
> > > > > >
> > > > > >
> > > > > > "Adam@nospam.com" wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I'm having to do a big database where I am reporting on
various
> > > > > > > departments over yearly periods, where there performance is
split
> > > > > > > monthly and measured in the output report.
> > > > > > >
> > > > > > > I have various fields, including a month field.
> > > > > > >
> > > > > > > What I would like is to have a report output whereby the
fields go
> > > > down
> > > > > > > the left, the months run across the top of the page (jan to
dec)
> > and
> > > > > > > the measures were then shown below that.
> > > > > > >
> > > > > > > I cannot see a way of doing this.
> > > > > > >
> > > > > > > Does anybody know how I could do this?
> > > > > > >
> > > > > > > Many Thanks
> > > > > > >
> > > > > > > Adam
> > > > > > >
> > > > > > >
> > > > >
> > >
>