Count/Quantity field

  • Thread starter Thread starter Pommy_g
  • Start date Start date
P

Pommy_g

hi,

i hav a table with these fields:

range colour size

the records will be of different combinations, and there will be
duplicates, so what i want to do is create a query that displays an
extra quantity field next to each different record, with no
duplicates.

I have only got so far as the "group by" and "count" function but i am
now clueless as to how to apply it to the scenario.

also is there any information about including quantities in databases?
is it good practice to do that or should each individual product have
its own record?

TIA
 
Assuming this is a products table:

Select Range, Color, Size, Count(ProductID)
From Products
Group By Range, Color, Size

--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
hi,

i hav a table with these fields:

range colour size

the records will be of different combinations, and there will be
duplicates, so what i want to do is create a query that displays an
extra quantity field next to each different record, with no
duplicates.

I have only got so far as the "group by" and "count" function but i am
now clueless as to how to apply it to the scenario.

also is there any information about including quantities in databases?
is it good practice to do that or should each individual product have
its own record?

TIA
Click to expand...
 
Back
Top