query a field based on a filtered date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that shows sales per store based on a queried date. Would it
be possible to show a second column of sales from last years date?
 
Dear JE:

Probably. If you would provide a query that does what you want but without
the last year's value, I could give it a try. Just post the SQL of that
query, in good working order, back here. Some example data might speed
things along as well.

If you already know how to do such things, the solution will probably be a
subquery using DateAdd to find the same date 1 year previous.

Tom Ellison
 
Back
Top