Concat Values Not Appearing in Query

[Londa Sue]

Hello,

I've created a field (Fld3) in a table (Tbl1) that is a combination of two
separate fields (Fld1 and Fld2) within the same table (Tbl1). I redesigned
the query (Qry1) to include the concatenated field (Fld3) so that I can pull
the data to use in an InfoPath form field (Fld4). When I run the query
(Qry1), however, I do not get the concatenated values, although the values
appear in the form.

Any thoughts on what I need to do so that the concatenated values appear?

Thank you,

 

[Lord Kelvan]

ok remove field fld3 from tbl1 because you shouldnt put summary fields
into a table thats what your query is for and in your query make your
expression to be fld3: fld1 + fld2 or fld3: fld1 & " " & fld2 and if
you do that you will see your concatinated values in the query for use

 

[Londa Sue]

Thank you.

 

[Lord Kelvan]

no problem