November 2nd, 2011, 08:03 AM
Parameter query to give a result if meets requirements
This is my code so far, its to select Number, Asset, Open Time, calculate the age of a ticket, and also lookup a owner of the ticket based on a lookup table.
, DATEDIFF("d",Ticket_Data.Open_Time,NOW()) AS Age
ON Cluster_Owner_Lookup.Asset = Ticket_Data.Asset
What i need it to do now is give me a range of the age so say if the ticket is 310 days old that the result should be >300 in the new column showing all the tickets with their new respective range.
My ranges should be 0-100, 101-200, 201-300, >300.
Would i start with a Like expression?
Btw this is in Microsoft Access right now