Re: Help with Concatenated / Nested Query results
From: Chris2 (rainofsteel.NOTVALID_at_GETRIDOF.luminousrain.com)
Date: 03/02/05
- Next message: sg: "How to create a ranking query with seq# in front of"
- Previous message: Anderson: "Auto Filter"
- In reply to: RNUSZ_at_OKDPS: "Help with Concatenated / Nested Query results"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Mar 2005 08:39:30 -0800
"RNUSZ@OKDPS" <RNUSZOKDPS@discussions.microsoft.com> wrote in message
news:6A5F4613-EE68-4D52-A10D-5E379B0D7395@microsoft.com...
> My appologies for double posting in two locations, forms and
queries. I had
> meant to place it in queries.
>
<snip>
>
> (TST_FR_CASE_RECORDS.LIC_FIRST_NME,
> TST_FR_CASE_RECORDS.LIC_MIDDLE_NME,
> TST_FR_CASE_RECORDS.LIC_LAST_NME,) and
> TST_FR_CASE_RECORDS.DOA_NME, and
> (TST_FR_ATTORNEY.FIRST_NME,
> TST_FR_ATTORNEY.MIDDLE_NME,
> TST_FR_ATTORNEY.LAST_NME,) and
> TST_FR_ATTORNEY.FIRM_NME,
> (TST_FR_CASE_OTHERS.OTHER_NME,
> TST_FR_CASE_OTHERS.FIRM_NME,)
>
> I need to create a print area as:
>
> cc: John Doe, Jane Doe, John Williams - Williams & Williams Legal
> Association,
> Mary Doe, Marty Doe, Jimmy Doe, Lonnie Smith - State Farm
Insurance,
> Mike Doe
Robert Nusz,
TST_FR_CASE_RECORDS.LIC_FIRST_NME & " " &
TST_FR_CASE_RECORDS.LIC_MIDDLE_NME & " " &
TST_FR_CASE_RECORDS.LIC_LAST_NME & ", " &
TST_FR_CASE_RECORDS.DOA_NME & ", " &
TST_FR_ATTORNEY.FIRST_NME & " " &
TST_FR_ATTORNEY.MIDDLE_NME & " " &
TST_FR_ATTORNEY.LAST_NME & " - " &
TST_FR_ATTORNEY.FIRM_NME & " " &
TST_FR_CASE_OTHERS.OTHER_NME & ", " &
TST_FR_CASE_OTHERS.FIRM_NME & ", " &
I wasn't able to interpret with certainty the naming and puctuation
structures, but the above should give the general idea of how to
concatenate columns.
>
<snip>
>
> 2nd question is do I need to nest a 2nd select statement to
concatenate the
> names with this first select statement, if so, would it be:
>
> SELECT Concatenate("OTHER_NME, FIRM_NME From TST_FR_CASE_OTHERS
WHERE
> CASE_NUM_YR = TST_FR_CASE_RECORDS.CASE_NUM_YR AND CASE_NUM =
> TST_FR_CASE_RECORDS.CASE_NUM) AS OtherNames From TST_FR_CASE_RECORDS
It depends on exactly how you are creating the Report.
Note: The microsoft.public.access.reports newsgroup is dedicated to
helping people with Access reporting solutions.
Sincerely,
Chris O.
<snip>
> --
> Robert Nusz
> Sr. Programmer Analyst II
- Next message: sg: "How to create a ranking query with seq# in front of"
- Previous message: Anderson: "Auto Filter"
- In reply to: RNUSZ_at_OKDPS: "Help with Concatenated / Nested Query results"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
