Last Month Data Using Month Field, Access 2013

[Biplab1985]

Hello,

I am trying to retrieve last month data using Month Field, I Do not have date field in the input data. I tried the below code but did not work.

SELECT * FROM Transpose WHERE Transpose.Month Between [Enter Month] and ([Enter Month]-1);

[orange]

I Do not have date field in the input data

What exactly are you comparing to what?

Asking a clear question will often get you focused responses.

Describe your situation/issue in simple, business terms. WHAT you are trying to accomplish.
Show some sample "input/raw" data.
Show us a sample of your expected output using the input data and the manipulation done on it.

Good luck.

[Biplab1985]

I need the data of the Last Month, When i input Apr and 2014 it should get me result for March. Result attached

I tried the below code but no luck

SELECT * FROM Transpose WHERE Transpose.Month Between [Enter Month] and ([Enter Month]-1);

[InsuranceGuy]

Try this:

SELECT * FROM Transpose WHERE Transpose.[Month] = monthname(iif(Month([Month])-1<1,12,month([Month])-1))

Best of luck,

Jeff

[orange]

cross posted and answered http://www.utteraccess.com/forum/ind...ic=2042403&hl=