problem with group of a repot

[pabloov]

Hi friends, i have making an Access report and i have a problem with it. It
hapends when i try to totalize a report field from a group. The report is
very simple, i recover a few rows like this:

Invoice Customer Warehouse Product Cost quantity

001 10008 1 art1 10 1
001 10008 1 art2 5 3
001 10008 1 art3 9 6
002 10009 1 art1 7 7


I make a group from Invoice:


Invoice: 001 Customer: 10008 Warehouse: 1
Product Cost Quantity
art1 10 1
art2 5 3
art3 9 6

Invoice: 002 Customer: 10009 Warehouse: 1
Product Cost Quantity
art1 7 7

If a try to make calculate field like Count(Invoice) at food of report the
result is 4 because there are 4 rows, but there are only 2 invoice and i
need to count the number of invoices. How can make this?.

(Sorry about my english, i don't write very well)

Thanks un advance.

 

[Kernow Girl]

Hi Pabloov - it sounds like you just need to make a Group Footer and put the
Count there. It will not show up at the bottom of the page but at the bottom
of the Group. Yours - Dika

 

[Douglas J Steele]

You could create a query that returns unique Invoice numbers for each
Customer:

SELECT DISTINCT CustomerID, InvoiceID FROM MyInvoiceTable

and then use DCount against that query.

 

[pabloov]

OK, thanks, i'll try it.

You could create a query that returns unique Invoice numbers for each
Customer:

SELECT DISTINCT CustomerID, InvoiceID FROM MyInvoiceTable

and then use DCount against that query.