I have been trying to figure this one out, but no luck so far.
I need to group several fields in a single record, so that I can plot them on a chart.
What I have is a db to track audiograms, so the tblAudo has fields like R500, R1K, R2K...... and L500, L1K, L2K......etc.
I would like to query this data, so that R500--->R8K of a single record is grouped AS "RightEar", and L500--->L8K is grouped AS "LeftEar"?
I have tried the following, but it puts all fields into one field.
SELECT BLL500 & BLL1K & BLL2K AS LeftEar, BLR500 & BLR1K & BLR2K AS RightEar, tblAudio.PatientID
ORDER BY PatientID;
Can this be done?, and What am I doing wrong?
Thank you for any suggestions...Enviva
Healdem, Thanks for your quick response.
I really don't want to concatenate the data I want to group the fields so that I have this.
Here's what I have:
a table for employees
a table for audiograms
The tables are related in 1-to-1 reslationship
The fields in (tblAudio) are:
AudioID, EmpID, L500,L1K,L2K,L3K,L6K,R500,R1K, R2K, R3K, R6K
The data in the record is as follows:
L500 = 5, L1K=10, L2K=10, L3K=5, L6K=5, R500=10, R1K=10, R2K=5, R3K=15, R6K=15
I would like to print the report for this employee with a graph or chart that displays something like this?
Well, I've run out of time, this is my attempt at a solution. The form can be used as a sub form in your main form or as report. I'm sure that you will need to redesign the form to meet your requirements. On the face of iut it seems to work.
***health warning*** its a quick and dirty solution, it should work but it could adversely affect perfomrance.