i'm using ms access, and i need to take the count of part of a date. all dates are in the format: "mm-dd-yyyy hh:nn" I need to count how many records there are from just 1 day. What is the SQL statement to do so.
That works great, just one thing left out. Check out this statement. The ED Visits are the total for the day. The Peg Visits should be the total of the EDMD for the day. (where the EDMD field is not null) This statement just returns the total for the day, whether or not there is something in the field or not.
Can't use a where edmd is not null statement, because that won't total the ED Visits for the day.
SELECT DateValue(timein) AS [Date], Count(DateValue(timein)) AS [ED Visits], Count(EDMD) AS [Peg Visits] FROM acctinfo GROUP BY DateValue(timein);