Results 1 to 2 of 2
2003-12-11, 18:06 #1
- Join Date
- Jun 2001
- Edinburgh, Midlothian, Scotland
- Thanked 0 Times in 0 Posts
Crosstab Query - Grouping (Access XP)
I'm trying to solve a crosstab problem.
I've written a query to extract the info I need, then I have a
Crosstab query to generate the crosstabed version.
It works fine apart from 1 problem. I want to show expenditure by
various headings (rows) by month incurred. When asked (in the wizard)
to choose "which interval" I want to group my Date/Time info, I
initially chose "Month".
This gives me a total of all January expenditure, then all Feb etc.
but it groups all Januarys, across all three years that I hold data.
If I choose Date/Time, I get the data in the right order, but grouped
by individual date, so I get individual entries, rather than month
Can I not group by month within year inside the Crosstab query, or do
I need to do this in advance?
2003-12-11, 19:27 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- Thanked 27 Times in 27 Posts
Re: Crosstab Query - Grouping (Access XP)
Try a format in there like:
Format(YourDate, "yyyy mmm")
If you want another format just change the mask in the formart.