Getting Month to show on report

  • Thread starter Thread starter sparky
  • Start date Start date
S

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
 
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
 
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.
 
Back
Top