CombineChildRecords with concatenated fields

[Guest]

I'm trying to generate a summary of loan rights from several fields in the
one record of a loans table and then combine this expression using Dwayne
Hookum's CombineChildRecords function for all records for the same library.

(I have not been able to access the link to Rogers Access library =
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
as posted in this newsgroup. HIs index does not list this under "G" or other
places either. Can anyone else?)

The expression is used in a query, entered into the Expression Builder:

Borrowing rights: CombineChildRecords("LOANS", "[LOANS]![group] & ': ' &
[LOANS]![items] & IIf([LOANS]![fee]=0,'',' ($' & [LOANS]![fee] & '.00)') &
IIf([LOANS]![items]='party hire','',' for ') & [LOANS]![duration] & '.' ",
"LOANS!TLid", [LIBRARY]![ID], "; ")

LOANS is the table I want to extract the information from, LIBRARY is parent
in a 1:many relationship with the LOANS table, group, items, fee and duration
are fields of the LOANS table; ID is primary key of LIBRARY; TLid is part of
the primary key of the LOANS table (links is on these 2 fields).

Is it possible to use the CombineChildRecords function for an expression? If
so, what am I doing wrong, please.

Thanks!

 

[Douglas J. Steele]

I just clicked on the link you posted, and it took me right to Duane's
example. Where does it take you?

You could try going to http://www.rogersaccesslibrary.com/OtherLibraries.asp
and following the link to Duane's samples.

 

[Guest]

The url is the same, but an error msg is displayed:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/Otherdownload.asp, line 32

Through the other links works fine, leading to the URL that generated the
error message, but I now see Duane Hookom's page .

Thanks.

I just clicked on the link you posted, and it took me right to Duane's
example. Where does it take you?

You could try going to http://www.rogersaccesslibrary.com/OtherLibraries.asp
and following the link to Duane's samples.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I'm trying to generate a summary of loan rights from several fields in the
one record of a loans table and then combine this expression using Dwayne
Hookum's CombineChildRecords function for all records for the same
library.

(I have not been able to access the link to Rogers Access library =
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
as posted in this newsgroup. HIs index does not list this under "G" or
other
places either. Can anyone else?)

The expression is used in a query, entered into the Expression Builder:

Borrowing rights: CombineChildRecords("LOANS", "[LOANS]![group] & ': ' &
[LOANS]![items] & IIf([LOANS]![fee]=0,'',' ($' & [LOANS]![fee] & '.00)') &
IIf([LOANS]![items]='party hire','',' for ') & [LOANS]![duration] & '.' ",
"LOANS!TLid", [LIBRARY]![ID], "; ")

LOANS is the table I want to extract the information from, LIBRARY is
parent
in a 1:many relationship with the LOANS table, group, items, fee and
duration
are fields of the LOANS table; ID is primary key of LIBRARY; TLid is part
of
the primary key of the LOANS table (links is on these 2 fields).

Is it possible to use the CombineChildRecords function for an expression?
If
so, what am I doing wrong, please.

Thanks!

 

[Guest]

Okay, nice. I only had the earlier version with CombineChildFields function.
The concatenate function appears to be less useful since I need to include
conditionals, and am not sure how to adjust Duanes's concatenate function
code to cope with changes in query output according to values in "items" and
"fee" fields.

Is it possible to use the CombineChildRecords function for an expression? If
not, how can I adjust the concatenate function to add the functionality of
the IIF statements below? If so, what am I doing wrong, please?

To recap:The expression is used in a query, entered into the Expression
Builder:

Borrowing rights: CombineChildRecords("LOANS", "[LOANS]![group] & ': ' &
[LOANS]![items] & IIf([LOANS]![fee]=0,'',' ($' & [LOANS]![fee] & '.00)') &
IIf([LOANS]![items]='party hire','',' for ') & [LOANS]![duration] & '.' ",
"LOANS!TLid", [LIBRARY]![ID], "; ")

LOANS is the table I want to extract the information from, LIBRARY is
parent in a 1:many relationship with the LOANS table, group, items, fee and
duration are fields of the LOANS table; ID is primary key of LIBRARY; TLid
is part
of the primary key of the LOANS table (links is on these 2 fields).

The url is the same, but an error msg is displayed:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/Otherdownload.asp, line 32

Through the other links works fine, leading to the URL that generated the
error message, but I now see Duane Hookom's page .

Thanks.

I just clicked on the link you posted, and it took me right to Duane's
example. Where does it take you?

You could try going to http://www.rogersaccesslibrary.com/OtherLibraries.asp
and following the link to Duane's samples.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I'm trying to generate a summary of loan rights from several fields in the
one record of a loans table and then combine this expression using Dwayne
Hookum's CombineChildRecords function for all records for the same
library.

(I have not been able to access the link to Rogers Access library =
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
as posted in this newsgroup. HIs index does not list this under "G" or
other
places either. Can anyone else?)

The expression is used in a query, entered into the Expression Builder:

Borrowing rights: CombineChildRecords("LOANS", "[LOANS]![group] & ': ' &
[LOANS]![items] & IIf([LOANS]![fee]=0,'',' ($' & [LOANS]![fee] & '.00)') &
IIf([LOANS]![items]='party hire','',' for ') & [LOANS]![duration] & '.' ",
"LOANS!TLid", [LIBRARY]![ID], "; ")

LOANS is the table I want to extract the information from, LIBRARY is
parent
in a 1:many relationship with the LOANS table, group, items, fee and
duration
are fields of the LOANS table; ID is primary key of LIBRARY; TLid is part
of
the primary key of the LOANS table (links is on these 2 fields).

Is it possible to use the CombineChildRecords function for an expression?
If
so, what am I doing wrong, please.

Thanks!