DCount syntax error when using WHERE...IN

[muse79]

Access 2013

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:

vCount = DCount("[SalesID]", "[Additional Costs]", "Where [SalesID] IN (" & vSelected & ")")

vSelected is a Variant and contains list of numbers for instance 62,63,64

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!

[Rabbit]

You don't need the where when using dcount.

[muse79]

What a silly mistake, thank you! Sometimes you can't see the wood for the trees!

[NeoPa]

As Rabbit says - The Criteria parameter, of DCount() and other Domain Aggregate functions, is the in the same format as the WHERE clause in SQL, BUT doesn't include the text 'WHERE '.