If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expression for combining multiple children with one parent in a qu
Need query to create a form with parent name and multiple children listed in
same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable: ChildID, ParentID, FirstName, LastName |
#2
|
|||
|
|||
Expression for combining multiple children with one parent in a qu
john15243 wrote:
Need query to create a form with parent name and multiple children listed in same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable: ChildID, ParentID, FirstName, LastName I don't understand. Why don't you use the Form Wizard to do this? Just start the wizard, select both tables when it prompts you for the table names (yes, you are allowed to select more than one table), and then tell it which table is the parent (master) table. When it's done you can look at the query it created and see what it looks like. Creating a query is similar: create a new query in Design View, add both tables, click and drag the ParentID from one table object to the other to create the join, and add the fields you want to the grid. -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" |
#3
|
|||
|
|||
Expression for combining multiple children with one parent in a qu
If I understand correctly, you might want to try the generic concatenate
function at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16. -- Duane Hookom Microsoft Access MVP "john15243" wrote: Need query to create a form with parent name and multiple children listed in same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable: ChildID, ParentID, FirstName, LastName |
#4
|
|||
|
|||
Expression for combining multiple children with one parent in
Hello,
I've tried copying the below site's example, but I get a "run-time" error message - "No value given for one or more required parameters." I'm not very familiar with modules, but I did copy the function from the example to my db. Was I supposed to modify anything with it? Below is what I've created in a query. Emails: Concatenate("SELECT email FROM qrycontactsExtended WHERE projectid =" & [projectid]). My Projects tbl has a one-to-many relationship with my contacts tbl. Actually, I have a "Projects and Contacts" tbl to deal with the many-to-many relationship with Projects and Contacts. Could this be part of the problem? Any help is greatly appreciated! "Duane Hookom" wrote: If I understand correctly, you might want to try the generic concatenate function at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16. -- Duane Hookom Microsoft Access MVP "john15243" wrote: Need query to create a form with parent name and multiple children listed in same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable: ChildID, ParentID, FirstName, LastName |
#5
|
|||
|
|||
Expression for combining multiple children with one parent in
what is the SQL for qrycontactsExtended ?
Warm Regards, Crystal remote programming and training http://MSAccessGurus.com free video tutorials http://www.YouTube.com/user/LearnAccessByCrystal Access Basics http://www.AccessMVP.com/strive4peace free 100-page book that covers essentials in Access * (: have an awesome day * cynteeuh wrote: Hello, I've tried copying the below site's example, but I get a "run-time" error message - "No value given for one or more required parameters." I'm not very familiar with modules, but I did copy the function from the example to my db. Was I supposed to modify anything with it? Below is what I've created in a query. Emails: Concatenate("SELECT email FROM qrycontactsExtended WHERE projectid =" & [projectid]). My Projects tbl has a one-to-many relationship with my contacts tbl. Actually, I have a "Projects and Contacts" tbl to deal with the many-to-many relationship with Projects and Contacts. Could this be part of the problem? Any help is greatly appreciated! "Duane Hookom" wrote: If I understand correctly, you might want to try the generic concatenate function at http://www.rogersaccesslibrary.com/f...sts.asp?TID=16. -- Duane Hookom Microsoft Access MVP "john15243" wrote: Need query to create a form with parent name and multiple children listed in same form. Tables include ParentTable: ParentID, FirstName, LastName ChildTable: ChildID, ParentID, FirstName, LastName |
Thread Tools | |
Display Modes | |
|
|