How to query 01-19-10

This is my table
Field1     Field2     
A              QQ
A              WW
A              SS
B              RR
B              HH
C              MM
D              FF

I 'd like query result like this

Filed1      FieldNew
A            QQ,WW,SS
B            RR,HH
C            MM
D            FF

How to create query?


0
Utf
1/19/2010 6:16:01 AM
access 16762 articles. 3 followers. Follow

1 Replies
914 Views

Similar Articles

[PageSpeed] 39

There is a generic concatenate function with sample usage at 
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16.

Duane Hookom
MS Access MVP


"Nova" <Nova@discussions.microsoft.com> wrote in message 
news:766EDBDA-7D79-4C1F-9370-34658288280A@microsoft.com...
> This is my table
> Field1     Field2
> A              QQ
> A              WW
> A              SS
> B              RR
> B              HH
> C              MM
> D              FF
>
> I 'd like query result like this
>
> Filed1      FieldNew
> A            QQ,WW,SS
> B            RR,HH
> C            MM
> D            FF
>
> How to create query?
>
> 
0
Duane
1/19/2010 6:22:58 AM
Reply:

Similar Artilces:

Office Update 10.2.3 kills network connections to shares.
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Don't ask me why, but I witnessed this myself. I just did a clean install on a 27&quot; iMac updated the OS to 10.6.2 set up several SMB shares and ran the final office update 10.2.1.(which I had disk images of) I left the clients place telling him to use the software update on MS Office for the remaining updates. He updated his Office to 10.2.3 and it killed the ability to connect to the shares I had already set up. I went back and tried to reconnect the shares and the &quot;Connect to Server&qu...

Money 2002 #19
All of a sudden the downloads from my bank show up as statements to read but when I open the account it doesn't show any new activity. I have tried manually downloading the account updates but that doesn't work either. The list of accounts continues to show statements to read. I have tried using the recovery tools but that didn't fix the problem. Any ideas Help In microsoft.public.money, Jerry L wrote: >All of a sudden the downloads from my bank show up as >statements to read but when I open the account it doesn't >show any new activity. I have tried manually...

Append Query 02-28-08
I am trying to append data from tblitemline to tblitemlist. I only want to append new records. The unique field is ListID. I want to append 4 fields total. I can't get it to limit it to new records. Any help would be appreciated. Thanks! New on the basis of what criteria.? Whatever that criteria is it should either the primary key (there can be multiples fields involved as the primary key) or Indexed with NO duplicates, (this will work if the criteria is a single field). Once you set the table up that way, the append query will only add "new" records. You can still have a ...

rounding problem 10-18-07
Hello, Is there any way of using the access round function with negative numbers? In excel I use round to account for significant figures {eg round(4563,-1) will return 4560}. I need to do this in access and I get an #error. Any suggestions greatly apprecated. Thanks Susan Unfortunately, the Round() function built into Access won't handle this. From memory, this one will: http://www.mvps.org/access/modules/mdl0054.htm (You will need to rename it as someone else so it doesn't get confused with the built-in one.) -- Allen Browne - Microsoft MVP. Perth, Western Australia...

Converting Leads 01-04-06
When converting multiple Leads associated with the same Account - shouldn't CRM 3.0 recognize that association and put them under one Account? I am seeing our CRM create duplicate Accounts (and contacts for that matter but I know it does not do dup-detection) I convert 5 ABC company Leads to Contacts and Accounts I should end up with ONE Account and 5 contacts associated with that Account. Is that right? Any advice? No, it is doing what you are telling it to do. You are telling it to create a new Account, so it is creating a new Account. Unfortuanately, there is no provided way ...

Update from previous versions to GP 10.0
Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and then GP 9.0 to GP 10.0? Please help me as soon as possible, I need to make decisions. Put service pack 5 on version 8, then update from there to 10.0 Make sure you also immediately use sp1 for Version 10 Mike "arielqs" <arielqs@discussions.microsoft.com> wrote in message news:12AD9FCB-84AD-45CF-898C-A943DB8216F4@microsoft.com... > Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and > then GP 9.0 to GP 10.0? > > Please help me as soon as possible, I need to make dec...

which query is faster, better to use?
There are multiple AdjournmentDates for any given NoticeID in tblNotices_AdjournemntDates. I want the most recent date for each NoticeID. Both of these produce the correct results. Is either one better than the other? SELECT DISTINCT NoticeID, (SELECT TOP 1 AdjournmentDate FROM dbo.tblNotices_AdjournmentDates WHERE NoticeID = A.NoticeID ORDER BY AdjournmentDate DESC) FROM dbo.tblNotices_AdjournmentDates A SELECT NoticeID, AdjournmentDate FROM dbo.tblNotices_AdjournmentDates A WHERE (AdjournmentDate IN (SELECT TOP 1 AdjournmentDate FROM tblNotices_AdjournmentDates WHER...

Integration 07-01-04
Hi Can anyone tell me if there has been any integration with the IPAQ 2210 and Microsoft CRM if so who and where can i get some info. There is a solution already which allows you to access your CRM data from a mobile device however this is simply a web style system ie if you do not have a data connection you cannot view your data. In August Microsoft should release a pocketpc addon for CRM which allows you to store the CRM data locally on your pocketpc. "Marlen" <m_fowler31@hotmail.com> wrote in message news:ehFIQfzXEHA.3100@TK2MSFTNGP09.phx.gbl... > Hi > > Can a...

Load query with outdata until search
I have a form with sub form on it I use this form to search for products we keep in stock with prices, I have a Search text box on the form then i type in the product then hit the search button and it requerys the sub form Only problem i have is when i first load the form it show every product in the subform, so takes a long time to load Is there a way to load the page with out the date then i can type in product i want to search for then it displays the products Simon What about setting the .RecordSource property of that form (?subform) to "" in the OnLoad event,...

query problem 02-11-08
Hi to Everyone I have a table (tblMunka) with the following columns: JobId; PersonalId;AreaId;StartDate;EndDate;ActiveJob I would like to a query which tell me how many personal was in a term in an area. I have a form (frmLetszam) where user can choose start and end dates from a calendar. I've tried with this but the result is not good: HAVING (((tblMunka.StartDate) Between [Forms]![frmLetszam]![cboEndDate] And [Forms]![frmLetszam]![cboEndDate])) OR (((tblMunka.StartDate)<[Forms]! [frmLetszam]![cboStartDate]) AND ((tblMunka.EndDate) Is Not Null)); Please help me! Best regards -- Mes...

database query/names issue, causing excel to be sluggish
I have an issue with an excel worksheet I've created. WorkbookA has "Names" which are used to define drop-down menus in WorksheetA. These "Names" are defined to reference a WorksheetB (also in WorkbookA) which itself is populated by a database query, pulling from another Excel WorkbookB. The logic is that WorkbookB should not be touched by the User, only an Admin, and Workbook A is used by User. The Names in WorkbookA are to prevent incorrect entries. Now that I've set it up, WorkbookA is moving really sluggish, but if I delete all the Names it speeds up again....

Microsoft Security Essentials 01-31-10
What is the best news group to subscribe to for Microsoft Security Essentials? I want to hear user comments and learn suggestions. Thanks This is a multi-part message in MIME format. ------=_NextPart_000_01BD_01CAA24C.D562DA00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable since it is still in BETA there are no public forums at this time. mikeyhsd@hotmail.com "mpdd" <mpddberry@yahoo.com> wrote in message = news:%23o3FZ7moKHA.5260@TK2MSFTNGP02.phx.gbl... What is the best news group to sub...

Money #10
Is there a tutorial in the form of a cd or book available that will give me step by step instructions on how to use my Money software which is already installed on my computer? I am trying to keep ongoing totals by month of expenses and income for a small business. In microsoft.public.money, Peggy Lynch wrote: >Is there a tutorial in the form of a cd or book available >that will give me step by step instructions on how to use >my Money software which is already installed on my >computer? > >I am trying to keep ongoing totals by month of expenses >and income ...

Page Numbering 02-18-10
I am trying to put page numbers only on the first page of each document in an appendix section of a large document. I have put section breaks between the different documents in the section. I was always able to do this in work 97 - can't get it to work in word 2007. You'll have to select the "Different first page" option in the Page Setup dialog box for the relevant sections. To display the Page Setup dialog, click the dialog launcher button (the little arrow on the bottom right) of the Page Setup group on the Page Layout tab. -- Stefan Blom Microso...

Appointments 05-14-10
I need to send out appointment requests to a number of people but only allow the users to read the entry and not modify the date and time of the appointments. Is this possible? I don't want to share my calendar or view there calendar. I don't want to have to use any programming languages either, if possible. Please help! Simply decline to accept any changes they request. Eddie wrote: > I need to send out appointment requests to a number of people but only allow > the users to read the entry and not modify the date and time of the > appointments. Is...

Windows Explorer 03-08-10
Im running Vista and IE8. Every time I try to move a file from one folder to another, "Windows Explorer has encountered a problem and will shut down" appears. Does anyone know how to recify this problem? Thanks It is a problem plaguing Windows Explorer in Vista and XP. Upgrade to Windows 7, or update your system. Windows update should do it. "Onky" <Onky@discussions.microsoft.com> wrote in message news:EB90CCEB-5CCA-4D50-B37F-7D1FC39F8F17@microsoft.com... > Im running Vista and IE8. Every time I try to move a file from one folder > to > ano...

CRM redeployment 10-04-04
Hi all, I have recently tries testing the redeployment of crm from one domain to another. I followed the steps in the redeployment guide yet it fails when i use the redeployment wizard to map users... I feel maybe it is something to do with having the same amount of users in each implementation or something... If anyone can shed light on this matter it would be very helpful...! TIA Emily ...

Trouble with IE 8 04-11-10
My new laptop was just working perfectly with IE 7 and Vista. Then IE 8 was downloaded automatically. Huge problelm as when I try to sign into Facebook and use Farmville or other apps it just loops to the login and insist that I adjust my cookie settings which I had tried to do numerous times but it doesn't seem to make any difference. The yellow triangle shows up in the bottom left with permission denied on several lines. What the heck does that mean? I'm not a computer techie and don't wanna be either. I just want things to work correctly when they're suppos...

Problem with Analysis Cubes for GP 10 FP1
I got it installed but when I try to run the SSIS packages I get an error. Error: Error 0xC0014049 while preparing to load the package. Cannot find folder "\DynamicsGPWarehouse\DynamicsGP_DynamicsWarehouse_CompanyMaster". What did I setup wrong or how do I fix? -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com Is the folder, in fact, there? I recently installed it using as much of the default settings as possible and had no problems. -- Charles Allen, MVP "Japheth Nolt" wrote: > I got it installed but when I try to run t...

system restore 08-09-10
i can't get system restore to go back to a previous month...i have only 2 restore points in august and i need to go back to july...i click on the previus month arrow but nothing happens...any thoughts? You don't have Restore Points going back that far? Your computer's infected & not fully-patched? jimgobucks46 wrote: > i can't get system restore to go back to a previous month...i have only 2 > restore points in august and i need to go back to july...i click on the > previus month arrow but nothing happens...any thoughts? jimgobucks46 wrote: >...

LDAP Query #4
im sorry if this post is in the wrong group how can i create an ldap query to get all the users with exchange boxes inside a specific OU this OU might also have OUs indise it with users that hafve mailboxes i want this to be able to create customized address lists Thank you Address Lists cannot be targeted at particular OUs. You need to use some user attribute that's common for users in that OU - like department, location, company name, etc. -- Bharat Suneja MCSE, MCT www.zenprise.com blog: www.suneja.com/blog ----------------------------------------- "Nazgyl" <naz...

Query with Combo Boxes on a Form
I'm using QBF with about six different combo boxes using: [forms]! [formmain]! [combo1] or [forms]![formmain1]![combo1] -like in a VBA book. This is so users can select criteria on a form with the combo boxes, and when they are done, they hit the search button, and it opens up another form based on the query just performed by the combo selection. This worked for about three combo boxes, but when I added another one, it freezes up and opens up a blank page. It's supposed to open the new form based on the query. Is there a better way to do this? Any help would...

Help with formula 04-20-10
Hi, I hope you can help me with this formula. I have two spreadsheets called the following:- 1) SME main 200410 2) SME PRE accounts CAT1_RCB checked 120310 (2) Coloumn A in both spreadsheets contains a list of numbers (e.g. 1012381211420) and both coloumns contain 6905 rows. I need a formula in cell b1 of spreadsheet 2 that will look at the number in cell a1 of spreadsheet 2 and if that number is in coloumn A of spreadsheet 1 then I want cell b1 of spreadsheet 2 to return a value of Yes if not then I want a value of No Thanls It's easier to set this up with bot...

Creating a Report using two queries
I have created a chart report (bar chart) using one query. How can I create another single chart showing the results of both queries. One will show the bars of first query data and the other will show bars of the data from second query together in a single chart report. Any suggestions? -- FL This depends on how/if the two queries are related. I would expect the "X" axis values might be related. If so, join the two queries into a single query and graph the new query. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www...

Complex Update Query in SQl Server 2000
I need to update ACTINDX in UPR40500 for each JOBTITLE in MYTABLE. We have modified the ACTNUMBR in 'MYTABLE' whose segments are contained in GL00100 GL00100 ACTINDX ACTNUMBR_1 ACTNUMBR_2 ACTNUMBR_3 ACTNUMBR_4 ACTNUMBR_5 30562 222 411001 000000 150 350 30563 222 411001 000000 155 355 UPR40500 JOBTITLE ACTINDX 209401 30562 150001 30563 MYTABLE JOBTITLE ACTNUMBR 209401 222-411001-000000-150-350 150001 222-411001-000000-155-355 Sean: If you are storing the account number as a string in my table, an...