How do I run a query that shows people to meet on today's date?

[Guest]

Hi - I use an Access database I have created myself at work. I teach students
who start their courses all on different dates. Approximately every 4 weeks I
am due to meet some of the students for a review. Each student has a record
on Access (in a form) that shows the date they started and automatically
calculates when they are due for their reviews. However, I want to be able to
run a single query tied to the date of the day I run this query and it will
give me a list of students who are due to be met by me on that day - ie If I
run the query for today it will only list the students I need to see that day
- I don't want it to list every student or when all their reviews are. I hope
this makes sense and that someone can help.
Regards - Raymond

 

[Jeff Boyce]

Raymond

Without some idea of what data structure and fields you have designed,
suggesting a query design is a bit hit-and-miss.

By the way, I thought that a calendaring program (say, Outlook) provided a
list of daily appointments. Is there a chance you could use this instead of
Access?