Need more information. If you want to see like, first available appointment, then yea, you could dlookup the first day without a record kind of thing. Need to know more though to suggest things. Do you mean you want to schedule appointments and have the option to either put the date in, OR pick from ASAP,soon, this week? What is ASAP? Next slot? What is soon?

Take a look at the Access Work Order Seminar.

It is set up to make scheduling pretty darn easy.  Also for the "next available" opening.  That might be right inline with what you are trying to accomplish.

Adam Schwanz My boss wants to see a calendar for the projects that have specific dates with a list on the side of projects that don't have specific dates but have a high priory or a date they need to be completed by. I want to schedule by having the option to either put the date in, OR pick from ASAP, soon, this week

I've got a whole bunch of different videos on appointments and scheduling. Bottom line is that if one of those doesn't meet your needs, you're going to have to learn how to build it yourself. That's the fun part! :)

Yea I would check out the videos Richard suggested. You could just have a checkbox in the table for "ASAP" or "soon" or "this week". And then have a listbox to the side with a filter based on records that have ASAP=True and ServiceDate=Null or something similar. Then buttons to change it to be Soon=True and/or ThisWeek=True

Hi Abigail, in my old job I used TODAY'S DATE for any urgent item that didn't have any "complete by" date.  I had customers who gave us orders that had to be shipped "ASAP" but they often left the complete date blank.  I entered the current day's date for it.  It would be updated with the Date() value for each day that it stayed incomplete.  In reports, the item would always appeared on top because it had the closest complete date.

For non-urgent tasks that are missing complete dates, you may use end-of-week or end-of-month dates.  For uncertain and open-ended tasks, you may even use end-of-year dates.  These are made-up dates that may be subject to change, so you need a way to update them when needed.

Thank you for your help.