The best I can come up with is this:
{SELECT ProductNames.Field1, Products.[Item Name]
FROM ProductNames INNER JOIN Products ON ProductNames.Field1 = Products.[Item Name];}
But, that creates an empty table for me so I'm still lost, lol
{Select Location & " " & Product As [Location and Product]
From Table1, Table2}
You guys are so much help, thank you very much for bearing with me here. My issue is I don't know SQL at all, and can't figure out which part is code, which parts of this to keep in. I've been playing with it...
Hi there! I've looked all over the internet for this solution, but I don't know what the technique is called so I'm not sure what to look for... Previously, I did this by hand. Then my computer crashed due to a virus attack and I lost my massive database. >:-<
Here's what I want to automate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.