Renewal Database

[deanovip]

Hi all,

I'm hoping somone can help, I' quite a novice to access so apologies. I'm trying to create a database that contact address information that has a expiry date. I currently have them on a spreadsheet with different tabs for different categories but all do the same.

My normal procedure as there is about 1000 on each tab, to sort them in nearest date first as they auto-renew upto 30 days early. From there I will check which have renewed for another year and manually update the expiry date, as some renew as late as 7 days.

Is there a way to use access and make this more efficent as the list is growing, ideally something like below:

ID - Address Location - Customer - Invoiced - Renewal Date - Vendor



Followed by a way to query all the ones from multiple tabs that expire soon, and maybe a click button to just forward them on a year or each time the button is pressed it adds a year onto the expiry, and as they are renewed they drop from the query and just the few left which my renew nearer the time are left?

Apologies if this isn't very clear, please let me know if you need anymore information.

[ranman256]

you want them all in a single database table. (not in various excel tabs)
then run queries to:
check on who is expired : ..where [RenewalDate]<Date()

who is about to expire: where DateDiff("d",Date(),[RenewalDate]) =<30

[deanovip]

you want them all in a single database table. (not in various excel tabs)
then run queries to:
check on who is expired : ..where [RenewalDate]<Date()

who is about to expire: where DateDiff("d",Date(),[RenewalDate]) =<30

Thank you so much and when it returns the query is there a way to implement a button to either renew selected ones by a year?