Joining Fields

[figurefour]

I'm trying to create a Purchase Order Database that requires a monthly summary of all the purchase orders in that month.

Examples of the fields i'm using are: Date, Vendor, Description, Item Number, Unit Price, Quantity, Sub-total, Total, etc.

Each table is a single purchase order, and there are around 3 or so every month. What I am trying to do is create a query in which all related fields are joined, and can be viewed as a single field.

For example:

Field 1 is DATE for Purchase Order (PO) 1, 2, and 3.

What I want to do is join all entries in DATE from PO1, PO2, and PO3 in a single query.

I want it to look like:

[DATE]
PO1......
PO2......
PO3......

I've tried several approaches to this problem, but they all have the same end result. It creates a seperate field for each table:

[PO1-DATE][PO2-DATE][PO3-DATE]



Any suggestions?

 

[Murli]

I dont know why you need to have seperate tables for each PO. You can have it in a single table with a PO# field set.

If you have multiple tables, you can use union to combine all those tables and then do a group by using the query.

Let me know if that helps.

 

[seth_belgium]

Yeah... Maybe you should take another look at your database-design... It isn't wise to have separate tables for what is essentially the same thing.