Solved: Access Query Count Records Per Day ?

[gunny2k9]

Hi,

probly an easy hting for you experts out there.

but i am erm new to SQL Access i can do vba in excel/word but not realy played with Access until now :P

basicly i have a VBA Tool in Excel that does a lot of converting of data and am basicly trying to make a log of whats done (yes i can do it in a text file and already have made code to do just that)

but i am have made code to log that data in Access ... reason being in access can setup auto reports etc etc ;)

so basicly right now i just looking for a Query that can count the number of records per day ... ?

eg total of say 13 records, but 7 came in on 29th, 1 on the 5th etc etc ?

attached a stripped down table example the code in excel logs
Date(Date Excel Tool Looked at the File), Filename FileOwner(who last saved the file), FileDate(lasttime the file was saved), and ProccesBy(who proccessed the file throught the Excel Tool)


ANY info welcomed lol a little over my head right now in :beerchug:

[gunny2k9]

Count Number Per Day:
SELECT [Date], Count([FileName]) AS NumOf
FROM LOG
GROUP BY [Date];


solved my own question lol, found once i had stripped the DB it was simplier then i thought lol dumb moment for me :banghead:

Count Totoal Records:
SELECT COUNT(*)
FROM LOG;

anyway post here for others ;p

juts need to mod the statement to be able to do by week and month etc then that be ace ;)