Recent content by clemensbarends

Thank you, but it hasnt helped. I now have a query (qry1sumofhealthages) listing these columns: IdClient / Age / Gender / Coughing:Coughing / Shingles:Shingles / Diarrhoea:Diarrhoea My forms uses Combo6 to get a textual record from Dtblinserttable: Autonumber: Column: 1...

How can i get the value from a combobox to be used as the column that needs to be searched/counted in an already existing query? I have a query with patient data: qryissuehealth. It has Idpatient (linking it to personal data) and several columns about complaint: "Shingles", "Coughing"...