repeat values in a multiple table query

  • Thread starter Thread starter mgm
  • Start date Start date
M

mgm

The goal is to retrieve data for an invoice. This invoice will have 5
different product tables plus one other query that has the customer's
billing info.
I want to eliminate the repeated values in the [labor_prod.labor_cost], and
the "contact_info.PONum" columns for each value in the
[materials.materials_cost] column.
Is this possible? What is the best way to do this?
Thanks in advance...
 
The goal is to retrieve data for an invoice. This invoice will have 5
different product tables plus one other query that has the customer's
billing info.
Click to expand...

Why *five product tables*? Are they all the same structure? Sounds
like you may have some problems with the table design!
I want to eliminate the repeated values in the [labor_prod.labor_cost], and
the "contact_info.PONum" columns for each value in the
[materials.materials_cost] column.
Is this possible? What is the best way to do this?
Click to expand...

Bear in mind - you can see your database. We cannot. I have no idea
how your tables are structured, nor how you built your query, nor
where these fields are coming from.

Please open the Query in SQL view and post it here, along with some
indication of what output you're getting, and how it's wrong.
 
Back
Top