Hi,
I know this should be so easy, yet I have a mental block on this at the moment. Please help.
tbl_myTable:
Columns/Fields:
- pkID (primary auto),
- clientName (text),
- q1 (text) - can only be "ABC" or "DEF" (from form's radio button group),
- q2 (text) - can only be "ABC" or "DEF" (from form's radio button group),
- q3 (text) - can only be "ABC" or "DEF" (from form's radio button group)
Example:
PK= 1
clientName = John
q1 = ABC
q2 = ABC
q3 = DEF
Desired outcome of Query:
1
John
2 - (count of ABC for John only)
Help needed with this query:
- Irrespective of which column it is (ie. q1,q2,etc)...
- COUNT(sum?) only all the "ABC" for John.
Please help with Query Design Grid for this.
Thank you kindly,
Jamie.
I know this should be so easy, yet I have a mental block on this at the moment. Please help.
tbl_myTable:
Columns/Fields:
- pkID (primary auto),
- clientName (text),
- q1 (text) - can only be "ABC" or "DEF" (from form's radio button group),
- q2 (text) - can only be "ABC" or "DEF" (from form's radio button group),
- q3 (text) - can only be "ABC" or "DEF" (from form's radio button group)
Example:
PK= 1
clientName = John
q1 = ABC
q2 = ABC
q3 = DEF
Desired outcome of Query:
1
John
2 - (count of ABC for John only)
Help needed with this query:
- Irrespective of which column it is (ie. q1,q2,etc)...
- COUNT(sum?) only all the "ABC" for John.
Please help with Query Design Grid for this.
Thank you kindly,
Jamie.