|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 29th, 2008, 02:15 PM
posted to microsoft.public.access
|
|||
|
|||
Query HELP !!
Hi all, I have a table with columns as below and want to create a query as
shown at the bottom, can anyone help, thanks in advance. Tony PRODUCT FAULT TYPE iron customer complaint television ok telephone warranty iron internal issue iron health & safety iron ok iron warranty iron ok iron internal issue television ok telephone Warranty What I want to see: PRODUCT FAULT TYPE TOTAL Iron customer complaint 1 Ok 2 internal issue 2 warranty 1 health & safety 1 television ok 2 telephone warranty 2 
|
|
#2
October 29th, 2008, 02:31 PM
posted to microsoft.public.access
|
|||
|
|||
|
Query HELP !!
On Wed, 29 Oct 2008 07:15:01 -0700, blake7
wrote: Use a Totals query. Something like: select Product, FaultType, Count(Product) from MyTable group by Product, FaultType Btw, I hope this is not really your table, or it would be a really bad table design. -Tom. Microsoft Access MVP Hi all, I have a table with columns as below and want to create a query as shown at the bottom, can anyone help, thanks in advance. Tony PRODUCT FAULT TYPE iron customer complaint television ok telephone warranty iron internal issue iron health & safety iron ok iron warranty iron ok iron internal issue television ok telephone Warranty What I want to see: PRODUCT FAULT TYPE TOTAL Iron customer complaint 1 Ok 2 internal issue 2 warranty 1 health & safety 1 television ok 2 telephone warranty 2
|
|
#3
October 29th, 2008, 04:19 PM
posted to microsoft.public.access
|
|||
|
|||
|
Query HELP !!
First things first, your tables need to be fixed. It looks like your tables
actually have "iron, telephone, etc" as its column names which is incorrect. Products ---------- ProductsID Product Faults ------- FaultID FaultType ProductFault -------------- ProductFaultID ProductID FaultID If you use the query wizard and built your query based on: the ProductName from the Products table, FaultType from the Faults table, FaultsID from ProductFault table. In the query edit view Group by ProductName, FaultType and set FaultsID to Count. -- Carrie "blake7" wrote: Hi all, I have a table with columns as below and want to create a query as shown at the bottom, can anyone help, thanks in advance. Tony PRODUCT FAULT TYPE iron customer complaint television ok telephone warranty iron internal issue iron health & safety iron ok iron warranty iron ok iron internal issue television ok telephone Warranty What I want to see: PRODUCT FAULT TYPE TOTAL Iron customer complaint 1 Ok 2 internal issue 2 warranty 1 health & safety 1 television ok 2 telephone warranty 2
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
