Condition query

[ngweixiong]

Hi all,

I have a query which i have already calculate the lead time.

Now, what i need is have another column in the same query.

THe Column should take reference from AvgOfTL PO and Inv

If my AvgOfTL PO and Inv is 0-7 days, It will show Status A
If my AvgOfTL PO and Inv is 7-14 days, it will show Status B
If my AvgOfTL PO and Inv is more than 14 days, it will show Status C

Below is my existing Access Query code

SELECT [lead Time between PO date and Invoice date].[PO date], [lead Time between PO date and Invoice date].PO, Avg([lead Time between PO date and Invoice date].[TL PO and Inv]) AS [AvgOfTL PO and Inv]
FROM [lead Time between PO date and Invoice date]
GROUP BY [lead Time between PO date and Invoice date].[PO date], [lead Time between PO date and Invoice date].PO;