counting records

[Jrw76]

I need to create a query that has two count fields. One will be a total Count of records- I have this, just Count(*). But I need another Count field where [Installed Date] is not null. Im apparently not getting the syntax correct. Also, these need to be conditional on what the user inputs into another field. So, in this query, I need the field "Hull" as one of the fields, and the Criteria to be [Enter Hull Number], so this will only count the number of records that have the "Hull" field equal to what the user inputs.but when I do this, it gives me an error. Do I need to go another route?

[JoeM]

Can you post the SQL code of your query?

[Jrw76]

Can you post the SQL code of your query?

SELECT Count(*) AS [Total Plates]
FROM [LABEL PLATE DATA];
SELECT Count('Installed By') AS [Installed]
FROM [LABEL PLATE DATA] WHERE Installed By Is Not Null;

[Jrw76]

The only part that will work is Count(*) AS [Total Plates] FROM [LABEL PLATE DATA];
Needs to return number of Records where Installed By has a value in it AND Hull = value entered by user.

[JoeM]

If there is a space in your "Installed By" field name, you will need to enclose it in square brackets (not quotes), i.e. [Installed By]

Programming tip: Never use spaces, punctuation (other than an underscore), or any special characters in field names. It makes it much easier to work with, and more easily allows conversion to other Programming Languages.

[June7]

This is a duplicate topic, solved in https://www.accessforums.net/sql-ser...rds-40761.html

Posting duplicate threads on same topic is against forum guidelines and just poor forum etiquette.