If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Report
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??????? |
#2
|
|||
|
|||
Report
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??????? |
#3
|
|||
|
|||
Report
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/...ddbuz/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??????? |
Thread Tools | |
Display Modes | |
|
|