Thanks David.
I tried your way but its not giving me what I want. I did some further research and came across the sql query mentioned below which is near to what I am after. I have adjusted it to my objects' names of course.
SELECT Year([ScanReceived]) AS Expr1, Month([ScanReceived]) AS Expr2...
I need some help with an issue in a database i am working on currently.
Basically the database that I have is a database for keeping account numbers of our clients. Among other things what is stored in the table is: name of account holder, the date account opening application is received and...
Hey everyone,
This is Chris from London.
I have been working with MS Access for the past three months and I am loving it. I have a lot to learn so I hope this forum will be the vault of knowledge which is what i need.
Cheers.