count query

[Lori]

I need to write a query that counts number of unique occurences of a
combination of 3 fields in the same table (Inventory): PC Brand, Operating
System, and Speed. How do I write this? I know how to write a count query
for one piece of data - I don't know how to do it for a combination of 3
fields. I am using Access 2000. Thanks!

 

[Mirek]

You can make it by using a combination of those fields in a query:
Combination: [PC Brand]+[Operating System]+CStr([Speed])
Use function CStr for numbers. Then set in query properties Unique values =
yes
Don't use Count function, only show number of records in a select query.

By, Mirek.

 

[Lori]

Hi,

Can you tell me more specifically what the syntax is? How do I get to the
query properties? The query properties that I found only tell me when the
query was made. Thanks!

You can make it by using a combination of those fields in a query:
Combination: [PC Brand]+[Operating System]+CStr([Speed])
Use function CStr for numbers. Then set in query properties Unique values =
yes
Don't use Count function, only show number of records in a select query.

By, Mirek.

I need to write a query that counts number of unique occurences of a
combination of 3 fields in the same table (Inventory): PC Brand, Operating
System, and Speed. How do I write this? I know how to write a count query
for one piece of data - I don't know how to do it for a combination of 3
fields. I am using Access 2000. Thanks!

 

[Lori]

Please disregard my previous post - I found the properties you referred to
and it works! Thanks a lot!

You can make it by using a combination of those fields in a query:
Combination: [PC Brand]+[Operating System]+CStr([Speed])
Use function CStr for numbers. Then set in query properties Unique values =
yes
Don't use Count function, only show number of records in a select query.

By, Mirek.

I need to write a query that counts number of unique occurences of a
combination of 3 fields in the same table (Inventory): PC Brand, Operating
System, and Speed. How do I write this? I know how to write a count query
for one piece of data - I don't know how to do it for a combination of 3
fields. I am using Access 2000. Thanks!