Export to Excel from Query, Need Pointers

[SaskiFX]

I'm working on the DB while others work on getting the data together, and the Stress data has not been recorded/extracted yet.



I have RawDetails and ExactDetails because the stresses will be coming from lots of different documentation. One doc might say "300ft/lbs of torsion caused failure", and another might word things differently and say "failure occurred after 300ft/lbs of torsion". That will go into the RawDetails, whatever the document listed as is. ExactDetails will be a field with some sort of standardization for that particular type of stress, likely a number with some text.

I'm keeping things vague for privacy, but basically the db is cataloging parts, and the parts have failure rates/methods associated with them. (Plus lots of other data.)

Yes, ItemID and StressID are compound PK on this table, and the ItemID is linked to another table of parts. That way each part can have multiple stresses. (Actually, now that I'm looking at my relationships in the DB, I have 3 tables. The Stresses table, the Item table, and a table in the middle that associates them. I guess that kind of over complicates things on my table design.)

[June7]

You still need to understand the nature of the data and build the database structure to accommodate. What you show is narrative text. I would think stress needs to be number type.

Hard to advise based on 'vague'. I still don't understand what you want and I am not sure you do either.

[SaskiFX]

Since the stresses can be different types (bending, compression, tension, etc) they will all have different methods for recording. One might be in pounds per square inch, the other might be in foot pounds, etc. I must not be explaining myself well, and I know its difficult to figure things out from just a forum posting.

I'm away from my desk for the rest of the day, tomorrow morning I'll see if I can post a better explanation or I'll make a dummy database based on mine to upload.