combining SQL COUNT

[andybeanland]

Hello,

I'm trying to do a simple count of who is attending on a register. What I would like to do is count the number of children attending (its for a nursery) for each day of the week and then create a report to show this. So far I've only managed to do several seperate counts which are like the one below:

SELECT Count([tbl_Monday.Attending]) AS NoOfChildrenAttendingOnMonday
FROM tbl_Monday
WHERE ([tbl_Monday].[Attending]=-1)

and I have one for each day of the week - just substitute Tuesday for every Monday etc...

Is there anyway that I can get the results for the whole week to be returned by one SQL statement?

Thanks for your help!

Andy

 

[PHV]

You have one table per day ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[andybeanland]

Yes, thats correct.