Pivot Table? Cross Query?

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi anyone,

I kinda stuck in rutt...
I need to create a report/form for analyzing the data...

Column headings are:
Customer TotalInvoice InvoiceOver30days InvoicesOver60days

Rows are:
Customer name, totalInvoices for this customer, then
amount for invoices which are over 30 days, then amount
for the invoices which are over 60 days...

HOW TO DO THAT? I have InvoiceDate Field.

Just give me some ideas...will you? Thanks. :)
 
Just made it. No need for help. Thanks anyway.
The way to do it - just one step at a time..:)

Have a good one.
 
You must log in or register to reply here.

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

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Excel Account Receivable Aging Report 1
Help somebody please.. getting no responce from other forums!!! 3
Access Default Microsoft Access Order Entry database issue 0
Access MS Access 2007 Aging Query 0
If over 60, then show all detail 1
To find due days of debtors 2
Developing invoices with transaction breakdown 1

Back
Top