Prior Month Information

[Jim]

I have a table which displays information by month. EX:

Name Sku Month
Jim 222 9
Sally 444 8

I am interested in creating query that would only pull the
prior month information. But I need it to be more
automated so I don't have to change the number each
month. I thought it was currentMonth - 1, but that isn't
working.

Thanks in advance,
Jim

 

[Dan]

Good Afternoon!

Try this to obtain the previous month:

Month(Date())-1

 

[tina]

try
Month(Date()) - 1

fyi, if you have prior years in the same table, you'll
have to get a little trickier - otherwise you'll have a
problem when you try to pull (for instance) 12/03 in 1/04.