Combining Two Fields and many rows

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining fields from different rows? 3
Creating a Unique ID by combining data from two other fields 3
Too Many Fields Defined Error 1
Add multiples rows for same date together 8
How to structure a Table with many, many, many Fields? 16
Combining Fields 1
Append Query 2
Convert Data from Unnormalized table 3

Top