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