Adding the count total of several fields

[Tom]

I can't seem to get a total of a group of fields. Each
field is a query sum of the count of items in the field
which is based on entry date and exit date (ie. inventory)

 

[[MVP] S.Clark]

Post your SQL.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Chris2]

SELECT COUNT(T1.Field1) + COUNT(T1.Field2) + COUNT(T1.Field3)
FROM Table1 AS T1.