Combining two fields in an update query

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

Guest

I would like to combine a Patient Id field and the Member Id field into one
field with a space between the two in an update query. I am having problems
accomplishing this and any suggestions you can give would be great. Here is
what I have tried:

[Patient Id]&" "&[Member Id]



Thanks.
 
This shouldn't be necessary since you can always concatenate the values in a
query.

I don't see anything wrong with your expression (other than the reason). Are
you getting an error or bad results or what? Can you share your full SQL
view?
 
I was able to get it to work with what I had in my original post.


Duane Hookom said:
This shouldn't be necessary since you can always concatenate the values in a
query.

I don't see anything wrong with your expression (other than the reason). Are
you getting an error or bad results or what? Can you share your full SQL
view?

--
Duane Hookom
MS Access MVP
--

LisaK said:
I would like to combine a Patient Id field and the Member Id field into one
field with a space between the two in an update query. I am having
problems
accomplishing this and any suggestions you can give would be great. Here
is
what I have tried:

[Patient Id]&" "&[Member Id]



Thanks.
Click to expand...
Click to expand...
 
Back
Top