Combining Two Fields and many rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 19 May 2008 14:36 GMT

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.

Reply to this Message

Jerry Whittle - 19 May 2008 15:04 GMT

Look into a crosstab query. It might meet your needs.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 4 lines]
>
> Any help would be appreciated.

Reply to this Message

Bob Quintal - 19 May 2008 15:36 GMT

> I have a database for apartments. One table lists all the
> amenities for the units. There are two fields from this table
[quoted text clipped - 5 lines]
>
> Any help would be appreciated.

Google for fConcatChild which is a module that does that sort of
thing, It's designed for a single column, but you could adapt it to
do two.

Signature

Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

Reply to this Message