Dates in Crosstab Query

S

sbeiler

In a crosstab query, can dates formated in months display data for more than one year. For example, when I use data from across two years it will display the total of two months of March in one column etc. can I have it show two columns for March. one for each year?
 
D

Duane Hookom

You can set your column headings expression to:
ColHead: Format([DateField],"yyyymm")

--
Duane Hookom
MS Access MVP
--

sbeiler said:
In a crosstab query, can dates formated in months display data for more
Click to expand...
than one year. For example, when I use data from across two years it will
display the total of two months of March in one column etc. can I have it
show two columns for March. one for each year?
 
Top