Joining text together from two fields

[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

 

[Arvin Meyer [MVP]]

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

 

[Guest]

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

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

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

 

[Guest]

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.

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

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