Joining text together from two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields containing a diagnosis code, i want to join the two codes
together in a separate column with two spaces in the middle. So far my
attempts haven’t worked, my attempted code is:

join: Left([Primary diagnosis],4) & " " & Left([Diagnosis 1)],4)

All it is bringing back when i run it is the left code and the two spaces.

Any help would be appreciated.

Annie
 
Thank you Arvin, i'll will check my spelling and re-run it. Fingers crossed.
;-)

Arvin Meyer said:
Assuming that your Diagnosis 1 field is correctly spelled, and there is data
in the field, your expression is correct.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

annied said:
I have two fields containing a diagnosis code, i want to join the two codes
together in a separate column with two spaces in the middle. So far my
attempts haven't worked, my attempted code is:

join: Left([Primary diagnosis],4) & " " & Left([Diagnosis 1)],4)

All it is bringing back when i run it is the left code and the two spaces.

Any help would be appreciated.

Annie
Click to expand...
Click to expand...
 
Actually, wasn't a spelling error after all, sorry but i've just realised the
problem after very close examination myself, my expression was: join:
Left([Primary diagnosis],4) & " " & Left([Diagnosis 1)],4) and i've just
realised some of my brackets were a bit mixed up now my expression reads:
join: Left([Primary_diagnosis],4) & " " & Left([Diagnosis_1],4)....but thank
you anyway.

Arvin Meyer said:
Assuming that your Diagnosis 1 field is correctly spelled, and there is data
in the field, your expression is correct.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

annied said:
I have two fields containing a diagnosis code, i want to join the two codes
together in a separate column with two spaces in the middle. So far my
attempts haven't worked, my attempted code is:

join: Left([Primary diagnosis],4) & " " & Left([Diagnosis 1)],4)

All it is bringing back when i run it is the left code and the two spaces.

Any help would be appreciated.

Annie
Click to expand...
Click to expand...
 
Back
Top