opening a report

[Cillies]

Hi!
In my access database I have a field that requires the user to enter in a call back date.

Now what I want to do is; when the DB opens the first thing it will do will be to scan the db and return a report with all records that display todays date.

I.e. so if I entered a date to call back in a weeks time, I want Access to remind me of it. Thus I would like to disply the result in a report or simply filter the form.

 

[bernie10]

Hello,

Okay first create a query based on the table with the date and any other data you have. Now the criteria for the query is going to be that the date field from your table equals todays date.

SELECT MyTable.Date, MyTable.Data
FROM MyTable
WHERE ((MyTable.Date)=Date());

That query will then give you the info you want. If you want to have it appear when your first open your DB you can create a form or page based on that query and have it open at startup (see tools-> startup).

Hope this helps,
Collen