1 Month Archiving Query

[Abarxax]

Hi Guys,

I was wondering if someone can help me? I am needing to create a query that will archive a record after the call has been set to closed for a month (its a basic help desk system) I did find this: http://office.microsoft.com/en-gb/ac...#_Toc254609926 on archiving so I have created a table but basically I need the query to check if it has been closed for more than a month and if so move it to the archive table. I am sure there is an easy way to do this but I don't have the syntax knowledge in access to do it.

Thanks in advance,



Abarxax

[pbaldy]

Your criteria would look like:

< Date() -30

or you could use the DateAdd() function to get an actual month.

[Abarxax]

Your criteria would look like:

< Date() -30

or you could use the DateAdd() function to get an actual month.

thanks Also would you by any chance know how I would make that query remove the record from that table and move it to my archive table because at the moment the query is just filtering.

[pbaldy]

You would run 2 queries, first an Append query then a Delete query, both with that criteria. With your query in design view you'll see icons to switch the type on the ribbon.