Hello, im new to this forum, and i need some help fast.

I have a database which is a list of all of member with some information and an expiry date for there membership. What i would like to be able to do is run a query and for it to search a table and give me the names of the people whos member ship has run out or is going ot run out within a month of the query being run.

I have tried several things already but access isn't realy my thing, i do Visual basic .net .

If any one has any ideas about how i could sort this would you please be able to respond, thanks in advance!

Create a query on the member table, and set the criteria as below under the YourExpiryDate field.
<=Date()+30

This should return all records whose expiry date has already passed or is within the next 30 days.

Thanks, that seem to of sorted. I knew it was something really simple like that but as i said I do visual basic and access isn't realy a strong point. I can use it enough to get around but not things like that. I had some wierd and wonderfull expressions trying to get that to work earlier.

You have been a great help, THANKS :D

Hi, sorry to Hijack this thread but the problem for you seems to be solved so no point in making another, i want *Exactly* the same thing except I dont have an expiry date in my table, i have another table with membership type .. this can be changed or upgraded etc.

So say the member joined on 02/02/2006 and he selected a 6 month membership, how would I go about setting it up, because the 6 month membership only has a code "6" in another table.

Confused :(

To solve your problem simple place 180 instead of 30. This will make the expiry date expire 180 days (6 months) from the current date

Amazing what the search function does!!!! Thanks for the answer to my question too!!!!:D