Comparing counts and deriving a value

[Luigi_Cortisone]

Hey Jal, two concretes and a wood are producing a wood, should be concrete

??

 

[jal]

Hey Jal, two concretes and a wood are producing a wood, should be concrete

??

I just tried that - worked fine for me in my test data that I posted just above. Are you talking about the data you uploaded? If so, give me the conductorID so I can see for myself.

 

[jal]

Nope, I think you're wrong. Look for example at Conductor 4125402
He has two concretes and a wood - it comes out concrete as it should.
Maybe you fed some bad data.

 

[Luigi_Cortisone]

Hey Jal

I tried to convert this to an update query and it screwed the results, otherwise its working perfectly

Many thanks for hanging in on this

Cheers, Luigi

 

[jal]

Hey Jal

I tried to convert this to an update query and it screwed the results, otherwise its working perfectly

Many thanks for hanging in on this

Cheers, Luigi

I don't understand. Why do you need an upate query?

 

[Luigi_Cortisone]

I needed to take the output and add it to a field in a larger 'conductors' table

 

[jal]

Sounds like an append query to me. Let's suppose you wanted to add two columns of my result set to another table. Let's assume you named my query "qryMaterial"

INSERT INTO LargeTable (ConductorID, Material)
SELECT ConductorID, Material FROM qryMaterial

or suppose LargeTable did not use those exact column names:

INSERT INTO LargeTable (ID, Substance)
SELECT ConductorID as ID, Material as Substance FROM qryMaterial

Such is an append query. Is that what you wanted?