Display records only for current year?

[ekta]

Hi:

I want to create a report that would display only those records entered in the current year. So if I run the report it will show records only for the year 2004. I have a date field in the table that records the date when the record was created. How should I use this date to achieve the above?

Thanks,

Ekta

 

[RichO]

Your report should be based on a query and the query set up to grab only those records from the current year.

In your query, add an expression field: Expr1: Year([MyDateField]) and then in the criteria for that field Year(Date()).

 

[AN60]

Ekta
I assume you mean that you want data for 2004 then next year you will want data only for 2005 & so on... If that is the case you should do as RichO said & base your report on a query. Then add the following to your date field criteria;

Between DateSerial(Year(Date()), 1, 1) And DateSerial(Year(Date()), 12, 31)

 

[ekta]

Thanks Rich and AN60.

AN60 you were right. I want to display the data only for that year. I created a query and it works fine.
I have one more question. I have 2 other fields that I want to display on this report and they are a checkbox. I want to show only those that are checked and then count the total under each category.

I have the db attached. Can you please take a look at it.

Thanks,

Ekta

 

[WayneRyan]

ekta,

Hope that's what you wanted.

Wayne

 

[ekta]

Thanks Wayne!

This is what I wanted.

 

[AN60]

ekta
I have only just noticed your earlier posting. It looks as if you now have what you want anyway. Good luck.