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
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