Find last date in series and test is within range

cambonner

Member
Local time
Yesterday, 20:45
Joined
Nov 30, 2012
Messages
36
Hi-
I new to the forum and new to Access, so please forgive any transgression or lack of experience. I am constructing a db in Access 2007 for a local food pantry and am having a problem constructing a query that will return those records of clients who have picked up food in the last 30 days. The table has 13 fields (excluding name, ID) that provides the dates in successive order that the client was given food. (We can only give food once every 30 days.) I record these dates in 12 fields for the calendar months and a 13th field to bridge between years. I need to construct a query and/or report that only returns those clients that have gotten food in the past 30 days, so that if someone stops by, we can quickly check if he/she is eligible.
Thanks in advance for your help. How do I write an expression that does this?
Cameron
 

Users who are viewing this thread

Back
Top Bottom