Combining Two Fields and many rows

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have a database for apartments. One table lists all the amenities for the
units. There are two fields from this table that I require for a report and
several rows for each property.

I know how to append two data fields( Amnt:=data1 &" "& data 2) but I'm
unsure how to combine the additional rows (may be 1 or 10 or etc..)

Any help would be appreciated.
 
Back
Top