Recent content by bclmx

I see where you're heading but this is just a part of inner join. In T-SQL the order of the tables is irrelevant unless many tables are involved in the query like (10-15). BTW id did try it anyway, no luck though.

Hey All, I need a little help with one of my update queries. Pretty much all I want to do is update one table (in Access 2007) based on the results from my pass-through query that pulls data from SQL Server. Please look at my update query below: UPDATE [SQL (2) Vendor cost export] INNER...

Thanks Wayne. There is one think I forgot to mention though. I need to set this up as a criteria in a query where I would sum order amt. Lets say I need to query 3 columns. Affiliate ID / Count of Customer ID /Sum of Order amt. So I have a table: Affiliate ID Customer ID Order amt 111...

Hey guys , I need to get a count of values from one column. The only problem is that each record appears more than once. Let’s call it Customer ID. How would I tell access to get a count of unique Customer ID’s? Here is an example. 111 111 111 222 333 444 444 444...

Hey Guys, I was wondering if there is a way to run queries automatically in sequence through Macro. Basically what I need is to automatically run query 1 then query 2 once the query 1 has finished and then the query 3 once the query 2 is done. Any idea how to do this? Is the only...

I think I did not express myself properly. But that's ok. I've solved the issue in the mean time. Thank you for the effort. Andy

This is my first time here so please be patient. I am having some troubles with IIF function. Hope this is just a dummy question and there is a simple solution for it. I am creating an update query where I want all the fields to be updated. That is not an issue here really what the problem is...