J
Jeff Lane
I have a simple query that gets all the results, that are not null, of one
column for a predetermined date from one table.
The results are 5 different text labels of varying amounts depending on the
month. the labels are 109, 231, 508, 606, 425.
Is there any way of producing a report that will count these?
i.e. Results for January
109=75
231=125
508=92
425=30
606=87
At the moment I export it to excel on completion and do a =counta() query.
it just seems to me there would be a simpler, more elegant way to do this?
I have attached the query code if it is of any use.
SELECT [Ryder Mot].Area, [Ryder Mot].[Test Date]
FROM [Ryder Mot]
GROUP BY [Ryder Mot].Area, [Ryder Mot].[Test Date]
HAVING ((([Ryder Mot].Area) Is Not Null) AND (([Ryder Mot].[Test Date])
Between #1/1/2004# And #2/1/2004#))
ORDER BY [Ryder Mot].Area;
All help gratefully recieved
column for a predetermined date from one table.
The results are 5 different text labels of varying amounts depending on the
month. the labels are 109, 231, 508, 606, 425.
Is there any way of producing a report that will count these?
i.e. Results for January
109=75
231=125
508=92
425=30
606=87
At the moment I export it to excel on completion and do a =counta() query.
it just seems to me there would be a simpler, more elegant way to do this?
I have attached the query code if it is of any use.
SELECT [Ryder Mot].Area, [Ryder Mot].[Test Date]
FROM [Ryder Mot]
GROUP BY [Ryder Mot].Area, [Ryder Mot].[Test Date]
HAVING ((([Ryder Mot].Area) Is Not Null) AND (([Ryder Mot].[Test Date])
Between #1/1/2004# And #2/1/2004#))
ORDER BY [Ryder Mot].Area;
All help gratefully recieved