Hi

I have setup a table and a form which consists of details of users. Each record has a date assigned to it. Each record is updated after 3 years and a new date is assigned to it.

I want to setup a command button, which will by a click bring back the records that need to be reviewed.

For example:

todays date is 28.08.01

So if i clicked on the command button today, it will bring back all the records dated 3 years old from today (records dated 28.08.98 should be retrieved).

i need to know how to do this please.

The user will have 2 choices on retrieving back the data, such as:

DataSheet View or Form View

How do i setup up the 2 command buttons(datasheet view & Form view buttons) to retrieve back data 3years old from todays date or tommrrows date and so on. it basically retrieves back records 3 years old from the present date.

Thank you in advance

Ruby

Please don't post the same question under multiple topics.