Expression for combining multiple children with one parent in a qu


J

john15243

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
 
Ad

Advertisements

B

Bob Barrows

john15243 said:
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.
 
C

cynteeuh

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!
 
Ad

Advertisements

C

Crystal (strive4peace)

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 :)
*

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 said:
If I understand correctly, you might want to try the generic concatenate
function at http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top