Dcount query (1 Viewer)

hi

can i use a Dcount function inside a query?

i have sample query here

VehicleNumber | MCUDate | SubSystem
01|12/06/18|doors
01|13/06/18|doors


so i am trying to create a query to look at the vehicle number and subsystem, and count then number of matching events over a 14 day period, i can do it on a form which i have the code, for but not quite sure how to do it in a query

You would ideally use a sub query - See here for an excellent resource.

You could use a DCount (or any other Domain function) in a query, but they get very slow very quickly, as they are effectively a single query that is run on every record you return.