Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query that will give single output of multiple records 1

Status
Not open for further replies.

rjmdt

Programmer
May 17, 2002
38
US
I have a table that has to give the exposure limits of a parent item. The child items determine the exposure limits based upon another table.

So it works like this

Parent item no. has a exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 2
Child item no3: exposure code 3
Child item no4: exposure code 4

It could also work like these examples
Parent item no has exposure code 1234
Child item no1: exposure code 14
Child item no2: exposure code 23
or
Parent item no has exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 23
Child item no3: exposure code 1
Child item no4: exposure code 2
Child item no5: exposure code 4

Each exposure number represents a differnt exposure for example
1=Light
2=Heat
3=Moisture
4=Cold
The child items combined make the parent exposure code.

So I have 3 tables: FMMAST (Parent) FMITEM (Child) INMOEL(exposure code)

FMMAST - Table
Parent Item No. - Field
Combined Exposure Limit - Field

FMItem - Table
Parent Item No. - Field
Child Item No. - Field

INMOEL - Table
Child Item No. - Field
Exposure Limit - Field

What is the best way to combine the child exposure codes into a field in the Parent Table.

Thanks in advance
 
The only way I can think to actually do what you are asking is to use VBA to step through all the related records and build your target field and update them in another table.

Kudos on providing schema information and asking a specific question. Unfortuantely I don't think you really want to accomplish this, just work around the way Access can do things using an easier method.

Perhaps you want a crosstab query to put all the values in the same record.

Maybe you want a subreport to display all the related information.

If that doesn't help, perhaps you could describe the goal you are trying to reach?
 
Did you search the FAQs in this forum? How about faq701-4233?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top