Append to an Append Query?? (1 Viewer)

[PaddyIrishMan]

Hi all,

Just wondering if anybody has any thoughts on the following?

At the Autoexec event, an append query runs, gathers the latest data from another database & appends to a table in the local database.

What I want to do is:
For each item returned from the Append query, prepend "CR".

I.e. 100, 120 & 350 returned from the external database, I want to append CR100, CR120 & CR350 to my local table.

any ideas??

Regards,
Patrick

 

[Rob.Mills]

What you need to do is setup a string expression. Try typing this where the name of the field from the other table is:

"CR" & FieldName

When you exit out of the field it will change it to:

Expr1: "CR" & FieldName

 

[PaddyIrishMan]

Perfect!!

Thanks Rob!