I'm developing a database for our Medical Department. They would like a tickler system that will remind them of upcoming appointments.

I want to create a layout that pops up at startup that lists 7 days worth of appointments from the current date that the database is being used.

My appointments table (MedAppoint) is set up as follows:

•ClFirstName – (text) Client’s first name

•ClLastName – (text) Client’s last name

•MedAppdate – (date) date of appointment

•MedAppType – (text) Type of appointment

•MedAppProj – (date) projected date of next appointment

•MedAppNotes – (text) Notes and comments

Any suggestions on how I should set this up to get a list of appointments from the current date out to 7 days? Sorry if this is in the wrong section. i wasn't sure if it should be here or maybe in scripting or calculations forum.

Maybe some of these links can help you?

Link 1

Link 2

Link 3

Not quite sure if that's your question, but I think you want a startup script that find records whose MedAppdate is:

Get ( CurrentDate ) .. Get ( CurrentDate ) + 7

Thanks for the help mr_vodka & Comment. ;)