I tried to build a query using count. What I want is to count the number of records where Flight.[battery id] a number like 2
I want to run this in vb code onclick of a button on a form I then want to display the count in a unboudn text field.
SELECT Count(Flights.[iBattery ID]) AS [CountOfiBattery ID]
HAVING (((Count(Flights.[iBattery ID]))=2));