Re: First - Last
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi Sean,
If a crosstab query doesn't do what you want, go to
http://www.mvps.org/access and search for "concatenate".
On Mon, 23 Jan 2006 11:47:02 -0800, "Sean"
<Sean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>My query is pulling 2 fields, Item and code. For each item I can have
>multiple codes, i.e. C1, C2, C3 and so on. When running a query for Item A I
>get back 4 lines becuase I have 4 different codes (C1, C2, C3, & C4). If I
>write my query using first and last I can return 1 line with Item, C1, and
>C4. Is there a way I can return all codes associated with the item in 1 line
>instead of 4? Like is there a second, and third function like the first and
>last? This way my result would be:
>
>ItemA C1 C2 C3 C4 instead of
>
>ItemA C1
>ItemA C2
>ItemA C3
>ItemA C4
>
>Thanks,
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
Relevant Pages
- RE: Concantenation HELP!
... I would think you would not include qryJCCSSListStar in your main query. ... SELECT tblAAStdTbl.*, Concatenate("SELECT CSSCode FROM qryJCCSSListStart ... sql statement inside the Concatenate() function. ...
(microsoft.public.access.reports) - Re: Concatenating text fields with a WHERE condition
... >>>concatenate the results of a field from several records into ... >> Dev's code works perfectly well against a query name passed ... >> as the strChildTable parameter, so your problem is for some ... > only took into consideration 1 criteria for the filter. ...
(comp.databases.ms-access) - Re: Converting from Access to SQL2k via Excel- HELP!!!!!
... you'll find a couple of VBA functions that will concatenate a field in ... multiple child records into a single calculated query. ...
(microsoft.public.access.conversion) - Re: Undefined funtion Concatenate in expression
... I don't get all the Repair Comments. ... Comments are there if I run just the Query but not when the Report prints. ... handle this would be to use five concatenate functions - one for each set of ... Flag Audits at a time. ...
(microsoft.public.access.modulesdaovba) - Re: Problem with concatenating multiple fields and records
... I want the query to concatenate the comments for each site using the field ... My table holds unique records for each audit performed (currently over ... As far as my table structure, it records things such as employee name, ...
(microsoft.public.access.queries) |
|
