A
Ashley
I have a query where I want to see the average price of orders in last
year in US or CANADA
AVG((IIf((([Location]="USA") Or ([Location]="CANADA")) And
(( datepart( 'y', ([ORDERDate])) = datepart('y' -1, getadte())
as [AVG COST LAST YEAR],
would I do -1 or what else??????????
year in US or CANADA
AVG((IIf((([Location]="USA") Or ([Location]="CANADA")) And
(( datepart( 'y', ([ORDERDate])) = datepart('y' -1, getadte())
as [AVG COST LAST YEAR],
would I do -1 or what else??????????