Expire date

[fixious123]

I have 12 immunizations and I want to send the personnel who are within 30 days of expiring to a table or seperate emailable form. Any input is greatly appreciated as Im beginning to understand this application.

Thanks

 

[fixious123]

Where does this go?

Where ExpireDate Between Date() and Date() + 30

Also in my query does all of the duedates have to be lined up. Not exactly sure on how to set all that up. Thanks again