Help With Query Design

[Van]

I have a table that consists of 20 fields. The fields are populated by
a form. The information feeds a report that looks simular to an
invoice. (ex. feild 1 - 1 box field 2 - expansion anchors) I am
attempting to group the information into 2 fields so that I am able to
sort them and use the information in another report. How can I achieve
this goal.

 

[[MVP] S.Clark]

In the query, or in the control source of the textbox, concatenate the
fields together that you need.

NewField: Field1 & Field2
=Field1 & Field2


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html