Thread: Changing Cloumna on a pivot table report in Access
View Single Post
  #2 (permalink)  
Old 01-17-06, 01:20 PM
koncept
Guest
  
Posts: n/a
i do not use crosstabs directly (typicaly custom coded in asp...) but your where statement
Code:
WHERE (((qryallstudy.OCC_DATE) Between #" & Me.StartDate & "# And #" & Me.End_Date & "# )) "
should be limiting the results you are getting. Is that part working? if so then you just want to hide the coloumns from showing correct?
Reply With Quote