Add a letter to the beginning of field

[srb3464]

When I run a query I want to preceed the result of one of the fields with the letter V.

ie. the field reads GH567Y and I want it to read VGH567Y

Thanks

 

[gromit]

Hi -

Use an expression for the new field. E.g.

NewField: "V" & tblData![OldField]

hth,

- g