J
julianp
I am trying to use the design view in Access XP to construct a query an
subsequently a report.
However I need to decode some values by comparing the coded results o
each column of the query with the code_decode table and then returnin
a decoded value from this table.
At present I am trying to workout what I should be entering in th
criteria box in the query designer to produce the following:
where decode.code_ref=table1.fieldname an
decode.code_val=table1.fieldvalue then return the value contained i
decode.decode_val
Table name decode
code_ref correspondes to the field in the table that we are decoding
code_val is the value assigned to coded data
decode_val is the translation of the code_val into plain English
I am not very good at entering SQL code and the query is already ver
long so the sql is complex. Thus I am trying to use the Access quer
builder where possible.
Any suggestions very gratefully received
Access is actually connected to a MYSQL Database through ODBC.
Julia
subsequently a report.
However I need to decode some values by comparing the coded results o
each column of the query with the code_decode table and then returnin
a decoded value from this table.
At present I am trying to workout what I should be entering in th
criteria box in the query designer to produce the following:
where decode.code_ref=table1.fieldname an
decode.code_val=table1.fieldvalue then return the value contained i
decode.decode_val
Table name decode
code_ref correspondes to the field in the table that we are decoding
code_val is the value assigned to coded data
decode_val is the translation of the code_val into plain English
I am not very good at entering SQL code and the query is already ver
long so the sql is complex. Thus I am trying to use the Access quer
builder where possible.
Any suggestions very gratefully received
Access is actually connected to a MYSQL Database through ODBC.
Julia