By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

appointment dates problem

P: n/a
I have a table with 14 days and appointment times. The days are numbered
0 to 13 (fortnight worth). I have a query (FortnightQuotesAppointments)
that adds now() to day number to get the date of the next 14 days.
I have a table/form with a combo box with the list of dates and times
for the next fortnight for a quote appointment from this query
(FortnightQuotesAppointments). I want to be able to delete the
unavailable appointments from the combo box. The way I am doing this is
by using a query and criteria, but I cant do it properly. Does anyone
have a suggestion to write a sql or query to delete the unavailable
appointment times from the query(FortnightQuotesAppointments)?
Thank you
Jul 27 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
You must have a way of determining which appointments have been
assigned. I am assuming you have a AppointmentDay, AppointmentTime and
PersonAppointmentWith....something to that effect. To determine which
appointments are available, query the records where
PersonAppointmentWith field Is Null.

Hope that at least points you in the right direction.

Jul 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.