I'm having trouble with my syntax. I'm getting a Run-time error 3075 missing operator
This is the code that is causing the trouble:
Expand|Select|Wrap|Line Numbers
- vCount = DCount("[SalesID]", "[Additional Costs]", "Where [SalesID] IN (" & vSelected & ")")
I want the DCount to count the records with the salesID 62,63,64 and return the number 3 (the number of records)
I want to use vCount in a msgbox which says "you have selected " & vCount & " records."
Thanks in advance!