DCount using OR for multiple critera

[adrianf44]

I'm trying to obtain a count from my Assets table with any EquipmentName that equals 5570, 5580, or 650 AND whether it is Checked In or Checked Out. Right now I'm using

=DCount("[ID]","tblAssets","[EquipmentName] Like '5570' or [EquipmentName] Like '5580' or [EquipmentName] Like '650' and [Status] Like 'Checked Out'")

It gives me a number but it is not accurate and I'm not sure what it is calculating

[isladogs]

Only use Like where you have wildcards.
Replace each with =.
Also put brackets around the three EquipmentName items so Access treats them as a group

[adrianf44]

That absolutely did the trick. Thank you!

[Minty]

As an alternative that might be easier to read you could use the "oft forgotten" IN() clause;

=DCount("[ID]","tblAssets","[EquipmentName] IN('5570' ,'5580' ,'650') AND [Status] Like 'Checked Out'")

Handy if you wanted to build a dynamic In() clause maybe from a select list box, then return a count.