I have a Table called 'Label Plate Data'. I need to count the number of records, which isn't a problem. This is the Code I used:
SELECT Count(*) AS [Total Plates]
FROM [LABEL PLATE DATA];
But in this same query, I need to count the number of records where a field is NOT empty. That field is 'Installed By'.
This query also needs to be populated by the decision of a users input for another field. That field is called 'Hull'.
So, when the query is run, it will ask the user Which Hull, then user then inputs the hull number and two values will be returned.
in specified hull-
1: Total number of records and
2: Total number of records where Installed by has data.
Please help.