I am having trouble writing a query that will do the following (any help would be appreciated):

I have a membership database with a field called "date_exp" and a field called "Member" which contains a "Yes" or "No". What I am trying to do is print out a message to let the member know whenever they login if their membership will expire within the next 30 days.

I know I can write an "if" statement to take care of determining if they are a member or not. But I am having a problem coming up with a query for the "date_exp" that will work for comparing the date_exp against current date at an INTERVAL 1 MONTH and against the members membership expiration date = "date_exp" that is currently logged in.

I hope I explained this well enough?

Any help getting me started in the right direction would be great !