Combine records in a single record

[George]

Dear friends,

I have two tables, e.g. Table1 (NumberOfPlot - Primary key)

Table2 (NumberOfPlot - foreign key, Species), which are related as One to
Many.

I need to create a query (?) to show in a single record the NumberOfPlot and
only the first 3 related records (species) in the following format, e.g.

ColumnA:121 (which is the plot number)
ColumnB: Pine, PineB, PineN (the first 3 related records of that plot)

Thanking you in advance

GeorgeCY

 

[Allen Browne]

You will need to write a function to concatenate the values from the TOP 3
related records.

Here's a starting point:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

You will need to modify it so the SQL statement selects just the TOP 3.

 

[George]

Dear Allen, Thanks a lot for the reply,

I have made some modifications on the structure of mmy database and I cannot
make this task. Here is the new layout of tables:

Tbl_CompartmentsAndPolygons: ForestID, CompNo and PolygonNo are primary keys.

Tbl_MainSpecies: ForestID, CompNo and PolygonNo and SpeciesID are primary
keys.

I would appreciate a lot if you could help me to use the given module in
order to achieve my task.

Thanks again,

GeorgeCY


Ο χÏήστης "Allen Browne" έγγÏαψε:

 

[Allen Browne]

Sorry George: I'm down with the 'flu at present, not able to think straight.

Perhaps someone else can make a suggestion.

 

[George]

Get well soon dear friend.

Ο χÏήστης "Allen Browne" έγγÏαψε: