Hi,
Can you help me. I need to count the number of invoices to a client for a report. eg
fldclient fldInvoice#
1 101
1 110
1 123
2 113
2 115
count client 1 has 3 invoices
client 2 has 2 invoices
etc
The dcount does not appear to be the answer.
Thanks for any help
Peter
Can you help me. I need to count the number of invoices to a client for a report. eg
fldclient fldInvoice#
1 101
1 110
1 123
2 113
2 115
count client 1 has 3 invoices
client 2 has 2 invoices
etc
The dcount does not appear to be the answer.
Thanks for any help
Peter