Implementation of Columns

[yourmomentofzen]

Hi all-

I saw a couple of similar posts like this, but I'm still a little
confused.

What I'm trying to do is to display our site names for rows (that's
the easy part) with the days of whatever month it is as columns and at
each intersection have the Rainfall total for that day and site. The
only problem I'm having is the actual implementation and coding for
how to set up the columns in the report. I have the rows set up, I'm
just not sure how to go about the rest. Any help is much appreciated.

Thanks.

 

[Duane Hookom]

Have you tried using a crosstab query as your report's record source?

 

[yourmomentofzen]

Have you tried using a crosstab query as your report's record source?
--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

To be completely and shamefully honest, I do not know really anything
about crosstab queries, but i guess i'll start doing some research.
Thanks.