Duplicate Data in Report

A

Alex123

Hello,

I'm running a report based on a query that is based on three tables, PO,
list of products in stock, SO.
The three tables are related by product number.
I wanted to see stock status, any open PO and any open SO by product in stock.
So I created a query as such PO <- Prod in stk -> SO

I run the corresponding report, group it by product and this is what I get:

Prod1
PO1 SO1
PO1 SO2
PO2 SO1
PO2 SO2

So I get double data. Iif I consolidate by PO I get the following:
Prod1
PO1
SO1
SO2
PO2
SO1
SO2

--> I don't want the SO data to repeat itself. This is what I'm looking for:
Prod1
PO1 SO1
PO2 SO2
or
Prod1
PO1
SO1
SO2
PO2

Can you let me know how I can do this ?

Thanks,
Alex
 
F

Fred

Alex,

From the way it looks, you are trying to list data of fundamentally
different natures and relationships in groups in reports. IMHO this is very
unusual and will require a very complicate unusual solution. Are you sure
you don't want to go the more typical route....2 reports: Products with PO's
under them, and then products with SO's under them?
 
A

Alex123

Hello Fred,

This is exactly what we're trying to walk away from. The goal was to combine
the two reports you describe into one so our mgmt can see the information
quickly.

Even though the data PO and SO are in two unrelated tables, listing them
next to each other would not be contradictory from a business standpoint.

If you know how to do this, I'll be more than happy to know.

Thanks,
Alex
 
D

Damon Heron

have you considered the use of subreports? That is one way of combining two
sets of data with one relationship -Products.

Damon
 
D

Dale_Fye via AccessMonster.com

How about creating the main report, which just has your Prod in Stk info.

Then, have two subreports sub_PO and sub_SO, where you place these subs in
the details section of your main report. They should be linked (master/child)
to the main report on the product number field. This would look something
like:

Product 1
PO1
PO2
SO1
SO2

HTH
Dale
 

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

Similar Threads

Merge data with Multiple-to-1 relationship 2
Summarizing data into different worksheet 1
i have a po report and i am trying to compare to budet 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to combine/consolidate data 2
Database problem 1
Subform causing duplicate records? 7
Nested Do...Loops and Date Cell Defined as Date in VBA code 4

Top