Re: Multi-valued field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Unfortunately, I'm not very familiar with writing in SQL; I usually work in
the design mode.

I like the idea of concatenating the values as a string, but since the there
are dozens of these, I don't want to list them all. Currently, I've written
the field as "ACTIVIITES: fConcatChild ([COMMCODE])", but that returns an
error message of "Undefined function fConcatChild in expression". Is there a
way around writing out the code?

"John W. Vinson" wrote:

On Mon, 2 Mar 2009 07:28:02 -0800, Jimmy G. <JimmyG@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I am trying in create a query in which an record (i.e., an individual) which
has multiple values in a joined table (i.e., activities in which s/he are
actively interested (e.g., travel, sports, reading, gardening, cooking)
appears as one row but all the associated values appear in separate columns.
I can't do a cross-tab query since the number of unique values are very large
yet the maximum numbers of values that any record had is five. Any
suggestions would be helpful. Thank you.

If it's just for reporting purposes, you can use a bit of code to concatenate
the child record values into a text string:

http://www.mvps.org/access/modules/mdl0004.htm

--

John W. Vinson [MVP]

.

Relevant Pages

  • existing code to build a sed-like?
    ... This means minimal syntax. ... Although the syntax is a mess, conceptually *nix scripts are very efficient ... and contain string string1 | ... can forth help by concatenating functions? ...
    (comp.lang.forth)
  • Re: Writing idiomatically for the cello and other string instruments
    ... writing for string instrument, specifically the cello. ... Also, get with a cello player and talk, ... Most of us sadly dont have a string player easily available- ...
    (rec.music.theory)
  • Re: To quote or unquote strings in an echo?
    ... However, for a double-quoted string with no dollar signs, the running time ... Complexity of both parsers will be Oin this case, ... using commas within echo() is a language construct. ... which leads us to the matter of concatenating stuff. ...
    (comp.lang.php)
  • Re: Rewrite last line in text file
    ... Now parse the buffer backwards, ... TFileStream to that point ... start writing your replacement string. ...
    (borland.public.delphi.language.objectpascal)
  • Re: Create Table SQL not working
    ... Tim & Jeff seemed to be so ... > concatenating the Number (converted to a string) to the end of a constant ...
    (microsoft.public.access.tablesdbdesign)