newyorkjets1721
New member
- Local time
- Today, 14:09
- Joined
- Jan 28, 2020
- Messages
- 9
I'm trying to use a DCount expression within a text field in a Form to populate how many entries a CustomerID has in a table. So if I have an entry pulled up in a form, there's a field that basically says "in addition to this entry, there's other 4 customer complaints associated with this CustomerID in the table"
I've been using the following expression but it's just returning a #NAME error:
=DCount("*","2020","[CustomerID]=" & [txtID])
Any tips?
I've been using the following expression but it's just returning a #NAME error:
=DCount("*","2020","[CustomerID]=" & [txtID])
Any tips?