Getting Month to show on report

[sparky]

Access97: I receive an invoice with costs from previous month, IE; May 23,
2009 invoice for April 09 billing. I enter invoice data into a table,
including invoice date. I have made a query to return all this data, but
have not put in criteria to select certain records based on invoice date.

I have made a report based on the query. On this report, I would like to
show the month of the billing, not the invoice date.

IE: "MONTHLY INVOICE FOR MONTH OF APRIL 09" which will contain data from
May 09 invoice.

I believe I will need to put this as criteria into my query, but I'm not
sure of wording.

I don't want to use a macro, as this database will be converted to
Access2007 in the near future, and Access2007 doesn't like 97 macros.

Any easy solutions?

Thanks

Rick

 

[tina]

well, if your query, or report, includes a billing date, then you can
calculate the invoice month as

DateAdd("m",-1,[BillingDateField])

that was off the top of my head, so check Access Help to verify the proper
syntax.

hth

 

[Klatuu]

You post is unclear as to the selection criteria, but as to putting a date on
your report like April 09, you can use the Format function to present that:
Format(InvoiceDate,"mmmm, yy")

If what you want is all invoice in that month to be included, then you can
filter the report's record source with:

WHERE Month(InvoiceDate) = ???
Where ??? is some field or control that deterimes the month to use.