Guys,
Searched high and low and I can't find anything at all for this.
I'm trying to create a query in Access that'll allow me to search a table, call it tbl_products and pick out from this data set all the products that are sold in different locations.
e.g.
LocationID,ProductID
1,1
1,2
1,3
2,1
2,4
2,5
So the query would pull back the result that ProductID 1 is found at both LocationID 1 & 2
I'm not sure what SQL statements to use for this at all, all the data is in one table tbl_products
Any help is greatly appreciated!
Regards
Searched high and low and I can't find anything at all for this.
I'm trying to create a query in Access that'll allow me to search a table, call it tbl_products and pick out from this data set all the products that are sold in different locations.
e.g.
LocationID,ProductID
1,1
1,2
1,3
2,1
2,4
2,5
So the query would pull back the result that ProductID 1 is found at both LocationID 1 & 2
I'm not sure what SQL statements to use for this at all, all the data is in one table tbl_products
Any help is greatly appreciated!
Regards
Last edited:
