Expression to collate text in a SubForm column

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Is there an expression to collate text in a SubForm column in the same way
that there is an expression to total numbers or count the records? If so,
please enlighten me. It will save days of collating. Thanks.
 
By 'collate' you did mean to sum the column did you not.
Open the form that is the subform in design view. Click on menu VIEW - Form
Header/Footer. This adds a header and footer to the form. Drag the headerto
reduce it's size to nothing.
Click on the toolbox icon - looks like a hammer and wrench forming an 'X'.
Click on the Textbox icon - contains 'AbI' - and then click in the footer,
hold down the left mouse button and drag to size the text box.
Click on menu VIEW - Properties. Click in the new text box and in the
Control Source property type in = Sum([YourColumnName]) and save.

If you meant something besides totaling the column then post back an
explaination.
 
Thanks for being so clear; and absolutely so if the data is numeric. But I am
trying to collate text. Thus the main Form may have a [Title] e.g.,
Mediterranean Fruits - and the SubForm column [KeySubjects] may list on three
separate rows e.g., Figs, dates, lemons and olives. I want an expression to
gather each of these texts and place them in a single text box that says
e.g., Figs, dates, lemons, olives
Is this possible, or is there another way to approach the problem? Thanks.

KARL DEWEY said:
By 'collate' you did mean to sum the column did you not.
Open the form that is the subform in design view. Click on menu VIEW - Form
Header/Footer. This adds a header and footer to the form. Drag the headerto
reduce it's size to nothing.
Click on the toolbox icon - looks like a hammer and wrench forming an 'X'.
Click on the Textbox icon - contains 'AbI' - and then click in the footer,
hold down the left mouse button and drag to size the text box.
Click on menu VIEW - Properties. Click in the new text box and in the
Control Source property type in = Sum([YourColumnName]) and save.

If you meant something besides totaling the column then post back an
explaination.
--
KARL DEWEY
Build a little - Test a little


Pete said:
Sorry, I am not managing. Need the application of a more skilful mind.
Click to expand...
Click to expand...
 
Search on 'Concatenate' and find post and link to Duane Hookom's generic
function query at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
KARL DEWEY
Build a little - Test a little


Pete said:
Thanks for being so clear; and absolutely so if the data is numeric. But I am
trying to collate text. Thus the main Form may have a [Title] e.g.,
Mediterranean Fruits - and the SubForm column [KeySubjects] may list on three
separate rows e.g., Figs, dates, lemons and olives. I want an expression to
gather each of these texts and place them in a single text box that says
e.g., Figs, dates, lemons, olives
Is this possible, or is there another way to approach the problem? Thanks.

KARL DEWEY said:
By 'collate' you did mean to sum the column did you not.
Open the form that is the subform in design view. Click on menu VIEW - Form
Header/Footer. This adds a header and footer to the form. Drag the headerto
reduce it's size to nothing.
Click on the toolbox icon - looks like a hammer and wrench forming an 'X'.
Click on the Textbox icon - contains 'AbI' - and then click in the footer,
hold down the left mouse button and drag to size the text box.
Click on menu VIEW - Properties. Click in the new text box and in the
Control Source property type in = Sum([YourColumnName]) and save.

If you meant something besides totaling the column then post back an
explaination.
--
KARL DEWEY
Build a little - Test a little


Pete said:
Sorry, I am not managing. Need the application of a more skilful mind.

:

Try using a footer on the form for totals.
--
KARL DEWEY
Build a little - Test a little


:

Is there an expression to collate text in a SubForm column in the same way
that there is an expression to total numbers or count the records? If so,
please enlighten me. It will save days of collating. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Excellent, many thanks.

KARL DEWEY said:
Search on 'Concatenate' and find post and link to Duane Hookom's generic
function query at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
KARL DEWEY
Build a little - Test a little


Pete said:
Thanks for being so clear; and absolutely so if the data is numeric. But I am
trying to collate text. Thus the main Form may have a [Title] e.g.,
Mediterranean Fruits - and the SubForm column [KeySubjects] may list on three
separate rows e.g., Figs, dates, lemons and olives. I want an expression to
gather each of these texts and place them in a single text box that says
e.g., Figs, dates, lemons, olives
Is this possible, or is there another way to approach the problem? Thanks.

KARL DEWEY said:
By 'collate' you did mean to sum the column did you not.
Open the form that is the subform in design view. Click on menu VIEW - Form
Header/Footer. This adds a header and footer to the form. Drag the headerto
reduce it's size to nothing.
Click on the toolbox icon - looks like a hammer and wrench forming an 'X'.
Click on the Textbox icon - contains 'AbI' - and then click in the footer,
hold down the left mouse button and drag to size the text box.
Click on menu VIEW - Properties. Click in the new text box and in the
Control Source property type in = Sum([YourColumnName]) and save.

If you meant something besides totaling the column then post back an
explaination.
--
KARL DEWEY
Build a little - Test a little


:

Sorry, I am not managing. Need the application of a more skilful mind.

:

Try using a footer on the form for totals.
--
KARL DEWEY
Build a little - Test a little


:

Is there an expression to collate text in a SubForm column in the same way
that there is an expression to total numbers or count the records? If so,
please enlighten me. It will save days of collating. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top