Report Columns

[OU18]

Hi All,

Once again I am in need of some help,
I have a query that has a Date Field in it. Along with that is a Count Field Associated to it. I need to produce a report that shows the Date across the top and the count below it.

So there could be 30 days, and each day will have a count associated to it.

3/1 3/2 3/3 3/4 3/5
1 1 5 6 9

That is the way I need the report to show when it is run. Can anyone help me solve this small problem

Thanks to DodgyChris for helping with my other issue, it might have been ugly but it worked great

 

[dodgychris]

Again, this ain't pretty... but might give you what you want... remember, if you turn this into a report, you don't have to display everything that the query produces...

TRANSFORM Sum(test.count) AS SumOfcount
SELECT "", Sum(test.count) AS [Total Of count]
FROM test
GROUP BY test.pieces
PIVOT Format([date],"Short Date"

Thanks for the Advil, my head's much better today...

All the best Dodgy Chris
-----------------------------------

confucious say : better to save a mans life than to build 7 storey pagoda

 

[OU18]

Dodgy,
Where do i put this code. I am looking for code to put in a report. If this is for the Report, where would i insert this information. Sorry for my lack of coding abilities.

 

[dodgychris]

This code is the query that you could use to base your report on. Obviously, you might want to put some Where clauses in it so you can select your dates. I'm not sure if there is any other way of doing it. (Although there probably is...)

If there is other data you want included in the report, could you post your original query on here and I'll take a look at it.

Thanks, Dodgy Chris
-----------------------------------

confucious say : better to save a mans life than to build 7 storey pagoda