Year Filtering on Database/Forms

[jurgen]

Can some one tell me how I can open a form and just display all records ex. created in 2001

We want to create a database were all events we organize are stored in, but at the start of the application we want to indicate the event and all the other forms etc, just showing all the records etc from that event?

Is this possible

Thankx

JJ

 

[JimHorton]

jj,
You can use Year([yourdatefield]) as an expression in the query, and use the year in question as criteria. But if this is a major part of the app, and you have many records, I'd suggest putting a separate Integer field in the table and set the default value to Year(date()), since you were looking for the year the record was created, or, if the year is the year of the event or whatever and not a record timestamp, then act accordingly and have that year field filled via the form (either behind the scenes or explicitly) with the proper year.
--Jim