I am creating a database that is like an appointment system where users can
book appointments for a predefined date but there are a limited number of
appointments for that date e.g. June 15, 2008 = 30 appointments, June 16,
2008 = 25 appointments.

What would be the best approach ?

CJCN

On Jun 4, 4:08*am, "cjcn" <u44045@uwewrote:

I am creating a database that is like an appointment system where users can
book appointments for a predefined date but there are a limited number of
appointments for that date e.g. June 15, 2008 = 30 appointments, June 16,
2008 = 25 appointments.
>
What would be the best approach ?
>
CJCN

You can use (slow) DCount() function to count appointments for
selected date and compare result with given number of max
appointments.

If there are lots of data and DCount() works really slow, you can use
SQL which counts appointments by date, like:

SELECT tblTable.Date, Count(tblTable.Date) AS CountOfAppointments
FROM tblTable
GROUP BY tblTable.Date;

and then use one of the methods to read the number of appointments by
date (Dlookup(), rst.FindFirst, etc). Once you have the number for
desired date you can compare it with max number of appointments for
that date and allow/disallow adding new appointment.

Regards,
Branislav Mihaljev
Microsoft Access MVP