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

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?
 
P

PC Datasheet

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
 

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

Concatenate multiple rows Into one Unique Identifier 1
Subform causing duplicate records? 7
Multiple rows to one row 9
Help with query to select the maximum date from a query 9
more efficient way to add lots of query criteria items 6
2-criteria query; 2nd criteria not regular 1
Limit recordset to top 1 per group 19
Copying Cells from One Workbook to Another Based on Specific Criteria 0

Top