View Single Post
  #1  
Old May 29th, 2010, 04:06 PM posted to microsoft.public.access.reports
M.K[_2_]
external usenet poster
 
Posts: 12
Default report in access (Count)

If i have data in CSV file and it show like belwo

Column1 Column2
ABCD Saturday
ABCD Saturday
EFGH Sunday
ABCD Saturday
MMM Friday
ABCD Monday
EFGH Monday

I want report show like

Saturday Sunday Monday Tuesday Wednesday Thursday
Friday
ABCD 3 0 1 0 0
0 0
EFGH 0 1 1 0 0
0 0
MMM 0 1 1 0 0
0 1


BR