I have a need to create a report that shows that patients are due for a review based on their admission date. The users need to be able to enter a date range then the report needs to return anyone that is due within that date range for their review.
my table is called tblClients
The fields that need to be returned are tblClients.ClientID, tblClients.FirstName, tblClients.LastName, tblClients.AdmitDate.
so if the users enter a date range of 1/1/2011 and 1/31/2011 then I need all of the patients that are due for their reviews which would be anyone who was admitted in January and or July only
Any help would be greatly appreciated as I need this ASAP!