query to find avg of ordertotal from last year and this year

A

Ashley

I need to find out the avg amount of Ordertotal for last 1 year and
this year


if location is USA or Canada

This query gives me error for present year and how do I do this for
last year



avg((IIf((([Location]="USA") Or ([Location]="CANADA")) And ((
(datepart( 'y', ([OrderDate]))) = (datepart('y', date() ) )),
Ordertotal ,0))) AS [Average Order Amount This year],



Will this work for last year probably not


avg((IIf((([Location]="USA") Or ([Location]="CANADA")) And ((
(datepart( 'y', ([OrderDate]))) = (datepart('y', dateadd('y', -1,
date()) ) )), Ordertotal ,0))) AS [Average Order Amount This year],
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
To find overage order amount for last year USE DATEDIFF or DATEPART or DATEADD 1
DATEPART, DATEADD or DATEDIFF ???I want data from last year 2
Query of customers who spent $x last year 4
Query to find the sum of fields... 2
Creating a Chart on form from selected data in query. 0
qry for dates in 1st 2nd 3rd and forth quarters of current year! 1
find last week of a year 3

Top