Recent content by BWiddoes

Hi Plog, your suggestion on the JOIN to subquery set me on the right track. I got it knocked out, jammed into one object. Main select pulling fields from the two tables my subqueries create SELECT cd.[SKU Code/Number], Count(cd.[Customer Code/Number]) AS [Customer Count], dc.[Cost Summary]...

Hi Plog. I really appreciate you taking the time to reply. I completely understand your solution and know how to get to it, but I was hoping to be able to knock this out in one go. I have some complex operations I am building and I want to limit the amount of make tables and queries to query...

What I want is to summarize the salestran.[Extended Cost] and salestran.[Extended Price] for each salestran.[SKU Code/Number], Count the number of unique customers, salestran.[Customer Code/Number], per SKU for any transactions equal to or after salestran.[Transaction Date] 11/1/2014. Problem...

ha, I just realized that. :rolleyes:

Problem is that I am using customer data and asking them to formalize it is not an option. I don't want to manually manipulate their spreadsheets so I thought bringing the data into access and performing a partial join would do the trick.. I am missing something though. The overall data...

Hopefully this is what you are looking for. All field Data Types are Text. I need to see every row from the Test_Items1 table and where the Test_Items1.[Part No] is in the Test_Products1.[Referenced Item], I want to see the associated Test_Products1.[Product Number] in my results.

Oh right. Yeah, I see how that would work. Problem is, I'm not sure how to use VBA to do that. Any good recommendations, ie links, forums, search phrases?

Hi Plog, let me know if this makes sense Test_Items1 Part No, Item SX Desc1 1317667223606,Tape Dispenser 1317667223614,Clear A/S Tape Test_Products 1 Product Number, Referenced Item 14_01, 1317667223606 1317667223735 1317667224517 1317667225406 Desired Results Part No, Item SX...

So I have read at least a dozen forums on this and all seem to have a solution but it is not working for me... Scenario, I have a table with Part No. and their correlating descriptions. I have a second table with a Product Number and its assosciated Part No. I want to view all of my Part No...