Counting Invoices per month (1 Viewer)

[sam1fletcher]

hi all
I have a table which has sentdate invoices and paiddat invoices. i want to be able to get a monthly count for the amount of invoices sent and paid to compare on a graph. e.g jan 2011 = 5 feb 2011 = 6 ect

Can anybody point me in the rite direction

Cheers

 

[DavidAtWork]

This would be an easy task if you had a monthly 'reporting table', to drive a graph as you've described above, you'd need a field to hold the month value ie "Jan 2011", 2 other fields, [Invoices Sent] and [Invoices Paid], plus any other monthly values you might want to include. The values in this table would need to be updated with aggregated monthly totals from your original table mentioned above. It will then be easy to create a graph based in this new reporting table

David