Prev: Query--using Access 2007
Next: What Formula Can I use
From: Pass-the-Reality on 1 Jun 2010 15:14
The Incurred Dates in my query run in rows. An example is below:

1/1/09 Date A 5.9
2/1/09 Data A 6.2
3/1/09 Data A 7.5

On my report I need to represent my dates as columns. Example below:
1/1/09 2/1/09 3/1/09
Data A 5.9 6.2 7.5

What is the easiest way to do this on a report without having to create a
new SQL statement. I am dealing with a lot of data. Any suggestions???????

From: KARL DEWEY on 1 Jun 2010 16:13
Crosstab query. Use the wizard to create it.
--
Build a little, test a little.


"Pass-the-Reality" wrote:

> The Incurred Dates in my query run in rows. An example is below:
>
> 1/1/09 Date A 5.9
> 2/1/09 Data A 6.2
> 3/1/09 Data A 7.5
>
> On my report I need to represent my dates as columns. Example below:
> 1/1/09 2/1/09 3/1/09
> Data A 5.9 6.2 7.5
>
> What is the easiest way to do this on a report without having to create a
> new SQL statement. I am dealing with a lot of data. Any suggestions???????
>
From: Duane Hookom on 1 Jun 2010 17:30
I would use the solution found at http://www.tek-tips.com/faqs.cfm?fid=5466.
You may need to change the month interval to days.
--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?


"KARL DEWEY" wrote:

> Crosstab query. Use the wizard to create it.
> --
> Build a little, test a little.
>
>
> "Pass-the-Reality" wrote:
>
> > The Incurred Dates in my query run in rows. An example is below:
> >
> > 1/1/09 Date A 5.9
> > 2/1/09 Data A 6.2
> > 3/1/09 Data A 7.5
> >
> > On my report I need to represent my dates as columns. Example below:
> > 1/1/09 2/1/09 3/1/09
> > Data A 5.9 6.2 7.5
> >
> > What is the easiest way to do this on a report without having to create a
> > new SQL statement. I am dealing with a lot of data. Any suggestions???????
> >
 | 
Pages: 1
Prev: Query--using Access 2007
Next: What Formula Can I use