I am trying to count the number of unique invoices using the following SQL in a query.
SELECT Count([InvoiceNo]) AS Uniques, [Invoice Log Table].[Batch Number] FROM [Invoice Log Table] INNER JOIN [IFIS Receipt] ON [Invoice Log Table].ID = [IFIS Receipt].InvoiceID WHERE ((([Invoice Log Table].[Batch Number]) Is Not Null));
I get the following error message:
You tried to execute a query that does not include the specified expression Batch Number as part of an aggregate function. (Error 3122)
Any help much appreciated