I want to query multiple rows into one column.What is the criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Text cells.
Purchase order DB
Each Purchase order in one row.
10 line items with multiple account codes per PO.
At the end of the month I need to filter by account code to view balances.
Help?
 
Your problem stems from the design of your table being incorrect. Needs to
be:
TblPO
POID
PODate
VendorID
etc

TblPOLineItem
POLineItemID
POID
ProductID
Quantity
Price
 
Back
Top