Query

[Guest]

Hello,

I have a inventory database. I like to know the PO and SO quantity.

i.e. I have 5 items, item1 to item5

item1 PO001 5 p.c.
item2 PO002 3 p.c.
item3 PO003 6 p.c.
item5 PO004 6 p.c.
item2 SO001 2 p.c.
item4 SO002 3 p.c.

my PO query will be
item1 5
item2 3
item3 6
item5 6

and my SO query will be
item2 2
item4 3

and so far so good, then I made another query to put PO and SO query together

I have one field is [PO Quantity] - [SO Quantity] only item2 show number 1
the other items just show space.

How can I fix this problem?

Thanks

 

[Vincent Johns]

Hello,

I have a inventory database. I like to know the PO and SO quantity.

i.e. I have 5 items, item1 to item5

item1 PO001 5 p.c.
item2 PO002 3 p.c.
item3 PO003 6 p.c.
item5 PO004 6 p.c.
item2 SO001 2 p.c.
item4 SO002 3 p.c.

my PO query will be
item1 5
item2 3
item3 6
item5 6

and my SO query will be
item2 2
item4 3

and so far so good, then I made another query to put PO and SO query together

I have one field is [PO Quantity] - [SO Quantity] only item2 show number 1
the other items just show space.

Actually, that's what I expected it to show, since "item2" is the only
matching value. What do you want it to show?

How can I fix this problem?

Thanks

It might help if you post the SQL that you're using, and maybe a list of
the fields in your Table (though that may be inferred from the SQL).
Also, an example of the output that you would like to see, based on the
data you listed, would be most helpful.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.