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?