How to combine to fields to one new name

[Guest]

I am very new to writing macros ...sorry this is so basic.

I have two fields PatientID and PatientSuffix. I want to combine these to
be field MemberID. What is the proper way to write the sintax in a select
statment of a macro?

Thank you!!!!!!!

Jill

 

[Steve Schapel]

Jill,

This is not a job for a macro. It depends *where* you want to use this
combined (concatentated) value. It would not be correct procedure to
store this MemberID in a table field. For your puroses on form or
report, you can take either if these two approaches:
- put a calculated field in the Query that the form or report is based
on, by typing the equivalent of this in the Field row of a blank column
in the query design grid...
MemberID: [PatientID] & [PatientSuffix]
- in the Control Source property of an unbound textbox on the form or
report, enter like this...
=[PatientID] & [PatientSuffix]

If you need more exlicit help with this, please post back with some
specific examples, and let us know what you want to achieve by this.