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
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