Report by year and month

yessir

Saved By Grace
Local time
Today, 03:40
Joined
May 29, 2003
Messages
349
I need to create a report off of the date the client started with the organization by month and year. (See pic)

the date can be found in client under Date_Entered.

Can someone please help with the setup?
I tried and failed horribly.

~Thanks!
 

Attachments

Take a look at the attachment. I had to make an extra field for the year. From there you can pretty much play around.

hth,
Michael
 

Attachments

You're a bloody saint

I have had a rough week (family death....) and this will really help as I have some other forms which use the same principals.

Thanks a lot
 
year field

did you input those by hand or run a query or what?
 
I made a crosstab query from your table. But I made a mistake by adding a year field (manual input). I made a correction for the year field that automatically inputs that year from the date your enter in Date Entered field. (hope it make sense)

Run your crosstab query you will notice that you have no 2005. Open your table and input today's date in Date Enetered field. Run the crosstab query you will see that you have a new year stored in year field from you're date entered field.

Field:Year: Year([Date_Entered])
Table:
Total: Groub By
Crosstab: Row Heading

Take a look at the new attachment. You have an extra field in a query that captures the year from your Date Entered field.

hth,
Michael
 

Attachments

thanks a lot, i was wondering if that would be the best way to do it rather than add another field.

+ i wasn't sure if it was that easy.

Thanks Again!
 

Users who are viewing this thread

Back
Top Bottom