Open ODBC table and concatenate field

[Allison]

I want to design a marco that will automatically open up a
table and concatenate several fields into one field call
the NEW GRANT ID. Is there a way to perform this???
If so can you fully explain. Keep in mind this is my
first macro!!!

 

[Steve Schapel]

Allison,

This is not a job for a macro. Whenever you need this concatenated
value for your purposes of form or report, you can do it in a calculated
field within the query that the form or report is based on, or within
the control source of a textbox on the form or report itself.

Please post back with more details, perhaps including example, if you
need more specific help with this.