R
raff98
I have a very simple table. It contains company # and and type (Type is #1,2
or 3) I want a total count of "Type 1", yet in my database a company # can
appear more than once. Example:
Company #100 Type 1
Company #100 Type 1
Company #200 Type 1
I dont want duplicates in company #'s, just the total of "Type 1" companies.
When I run my query, it shows "3" "Type 1" companies, yet in reality there
is only "2" distinct "Type 1" companies. Also, how do I show "2" companies
in a report
Very new to access. Thanks!
or 3) I want a total count of "Type 1", yet in my database a company # can
appear more than once. Example:
Company #100 Type 1
Company #100 Type 1
Company #200 Type 1
I dont want duplicates in company #'s, just the total of "Type 1" companies.
When I run my query, it shows "3" "Type 1" companies, yet in reality there
is only "2" distinct "Type 1" companies. Also, how do I show "2" companies
in a report
Very new to access. Thanks!