Expiry date in Access

[31si]

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!

 

[antomack]

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.

 

[31si]

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

 

[DCXtreme]

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

 

[31si]

I got your answer

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

 

[chef_tim]

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