Search results

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...

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...

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...