1 Month Archiving Query (1 Viewer)

abarxax

New member
Local time
Today, 08:43
Joined
Apr 18, 2014
Messages
3
Hi Guys,

I was wondering if someone could help me?

Basically I need the query to check my jobs table and look for jobs that have been set to closed for one month or more (its a basic help desk system) I have a call open and call closed date. once they have reached a month or more I need it to archive that record. I am sure its not a difficult query but I am very rusty with Access syntax.

Thanks in advance,

Abarxax
 

spikepl

Eledittingent Beliped
Local time
Today, 09:43
Joined
Nov 3, 2010
Messages
6,144
Don't muck about with syntax for starters. Use the QBE, the query builder, and play with it - switch views between SQL and Design and see what corresponds to what.
 

abarxax

New member
Local time
Today, 08:43
Joined
Apr 18, 2014
Messages
3
Thanks, I have had a play around with it and I can't seem to get it right. do you have any thoughts on how I would get access to follow that criteria? it would be something along the lines of IF BETWEEN Closed_Date AND Today_Date > 1 month THEN Archive to Jobs_archived but I don't know how to translate and integrate that into a query.
 

Users who are viewing this thread

Top Bottom