Find "Like" Orders Query

[bmhuettinger]

Good morning all,
I'm not new to Access but I've been on Access hiatus for several years and I'm realizing that building databases isn't exactly like riding a bike; I've forgotten a few of the basics. I know this request is super elementary but I can't figure it out:
I have a query [SalesOrdersWaitingOnPurchaseOrders] that looks up a value in [SalesOrderDetail].[IncomingPONumber] and returns PO details like [Vendor], [Quantity], and [DueDate] information from [OpenPoTbl]. I need to create another query (or additional columns in [SalesOrdersWaitingOnPurchaseOrders]) that shows me other purchase orders that match the [type],[fin],[dec],[width] of the criteria [IncomingPONumber], but have different PONumbers and/or Vendor Names - essential "like" material on order.
My apologies in advance if this questions has been posed and answered, my google searches came up short as I'm afraid I don't really know how to pose the question properly.
Thanks! B

 

[plog]

Demonstrate your issue with data. Provide 2 sets:

A. Starting data from all relevent fields/tables. Include table and field names and enough sample data to cover all cases.

B. Expected results of A. Show us the data you hope to end up with when you feed this query the data in A.

 

[bmhuettinger]

thank you for the quick response. Unfortunately, I don't know how to post forms/tables/queries.
Query:
tbl_SalesOrderDetail.IncomingPONumber >>>>tbl_OpenPO.PO

returns tbl_SalesOrderDetail.SONumber AND tbl_OpenPO - [VendorName], [POQty], [PODueDate], [type], [size], [width]

What I would like is results that, in addition to the details of PONumber in question, other tbl_OpenPO.PO's that match the [type], [size], and [width].

current results:
tbl_SalesOrderDetail.SONumber - S823859
tbl_SalesOrderDetail.IncomingPO:E21595- tbl_OpenPO.PO:E21595
tbl_OpenPO.PODueDate - 8/20/17
tbl_OpenPO.Vendor - Acme
tbl_OpenPO.POQty - 10,000
tbl_OpenPO.Type - 718
tbl_OpenPO.Size - .030
tbl_OpenPO.Width - 36

Looking to add any additional POs that meet 718, .030, 36, criterion even though the PONumber, Vendor, Due Date and Qty may/will be different.

 

[plog]

Post data in this format:

TableNameHere
Field1Name, Field2Name, Field3Name
Jerry, 12/3/2016, 27
Sam, 1/14/2008, 41
Steve, 2/13/2000, 2

 

[bmhuettinger]

tbl_SalesOrderDetail
SONumber , IncomingPO
S823859, E21595

tbl_OpenPO.
PO, PODueDate, Vendor, POQty, Type, Size, Width
E21595, 8/20/17, Acme, 10,000, 718, .030, 36

Would like to see additional POs that meet identical Type, Size, Width criterial

 

[plog]

One more try:

Demonstrate your issue with data. Provide 2 sets:

A. Starting data from all relevent fields/tables. Include table and field names and enough sample data to cover all cases.

B. Expected results of A. Show us the data you hope to end up with when you feed this query the data in A.

I think you gave me A, now give me B. Also, that's not a lot of sample data.

 

[bmhuettinger]

I don't know how else I can explain it but thank you for time. Have a nice weekend.

 

[plog]

Nor do I. Which is why I don't want you to explain it. I want you to show me.

 

[Minty]

You have only give us 1 example of each data type and no example of the data you expect to see.

We would need 4 or 5 lines of each table and then what you expect to see as a result. And the examples should be correct enough data to give the desired results.

The first post here https://www.access-programmers.co.uk/forums/showpost.php?p=1512658&postcount=1 provides exactly the sort of data / examples we need. You can make them up in excel and simply post a picture of that if it's easier.

 

[bmhuettinger]

thank you, Minty, for the visual. I (think) that I understand what I need to do now. I'll work on it this weekend, and hopefully I'll be able to make my issue clear enough for resolution! Have a great weekend!
Brandi