Monthly Reports using a different reference field each month

[godshuddle]

I have a table for cell phone billing. Each month has an invoice date field, charges field, ect. (i.e. jan_invoice_date; feb_invoice_date) When I created a query to run the montly report I have to change the month that I am focusing on by changing a field being searched in the query. Is there a way to manipulate the query or report so I could type in the month I want and it knows to go to that month's field?

 

[SteveA]

I would probably change the design of the invoice table to not have seperate fields for each month ie:

Invoice Table:
InvoiceID
CustomerID
InvoiceAmount
InvoiceGeneratedDate etc

This will allow you to run your report easily, be able to generate statistics across months easier and also provide for more than 12 invoices for a specific customer.

It's a bit of work but the end design will make life easier in the long run.

HTH
SteveA