Formatting

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

Guest

I'm trying to have my query output the current month minus one month: So if
it's October I want it to show up in my query as September. This is what I
have in my Field: Current Month: Format(Date(),"mmmm") but I can't get it to
show September. If tried -1 but I must have in the incorrect order. Thanks
 
I'm trying to have my query output the current month minus one month: So if
it's October I want it to show up in my query as September. This is what I
have in my Field: Current Month: Format(Date(),"mmmm") but I can't get it to
show September. If tried -1 but I must have in the incorrect order. Thanks
Click to expand...

In addition to Karl's expression, you could use:

MonthName(Month(Date())-1)
 

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

Using Crosstab column headings for conditional formatting in report 0
Sort by Summed Date 3
Month on Report 3
fill in blanks 1
Query current fiscal year 2
Sort month chronologically 5
Arrange the months in Asending 2
Criteria for current month, current year 6

Back
Top