Dates in Crosstab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top