I am stucked (1 Viewer)

[Jackske]

I did a query which shows all record with 'Y' in a field.
I would like to have also a field with the total of all the records in this query.
The problem is that the field with 'Y' or 'N' is a text field.
Thanks,
Jackske/Belgium

 

[maxmangion]

how can you total a field with 'Y' ? Do you mean Count the number of records ?

 

[Jackske]

how can you total a field with 'Y' ? Do you mean Count the number of records ?

Yes, I want to count the number of records!

 

[maxmangion]

create a total query, by clicking on the Σ icon which is on the toolbar. A Total row will be displayed in your query grid. On the 'Y' field click on the drop down arrow in your Total Row and select Count.