Pivot Table? Cross Query?

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. :)
 
G

Guest

Just made it. No need for help. Thanks anyway.
The way to do it - just one step at a time..:)

Have a good one.
 
Top