I am trying to create a field that counts how many orders a customer has placed.

As a report, it's easy: Find CustomerID and sub-summary count OrderID. But can I get a FIELD to accomplish this?

If you have a Customers table, you can define a calculation field there =

Count ( Orders::CustomerID )

Or just place the summary count field from Orders on the customer layout.

If you have a Customers table, you can define a calculation field there =

Count ( Orders::CustomerID )

Or just place the summary count field from Orders on the customer layout.

yup, the first suggestion did the trick. Funny how, as a newbie, it's easy to overthink things.

Thanks comment

Edited August 15, 201016 yr by Guest