Search results for query: *

I tried the script suggested by Jerry, but Access doesn't like it. I'm guessing it would work outside Access.

As an update, I cleaned up the query hoping that was the problem - modified it by removing the SQLtable that was not needed and ended up with this... which acts the same way. UPDATE dbo_ExamRecord INNER JOIN Tracking ON dbo_ExamRecord.AccNumber = Tracking.AccNumber SET...

Okay, I'm starting to think the problem is elsewhere in Access and not witht he query. The query seems to be working as it should. Turns out I need both SQLtables to build the local table, but only need to hit one SQLtable to build the update query. The query goes to dbo_ExamRecord as it's...

JerryKlmns : >>change factoring in two different SQLTabels (this is a combination of info pulled from two different tables)? >Sorry I don't unnderstand that question.Could you explain it a bit more? The original code has the information pulling from one external SQLtables, but I am pulling...

Thanks a million, it's starting to take shape and make sense at least at the SQL level to me. Can you show me how the above code would change factoring in two different SQLTabels (this is a combination of info pulled from two different tables)? I have a condtional parameter so it only pulls...

Update: I finally got it to run and stop prompting for the parameter value by adding the destination table as a table in the query setup (rather than just entering it directly). Now it appears to run without thrashing the parent database it's pulling from, though it does take a couple of...

Also, I am getting pop-ups when I try and run the query asking for "enter parameter value" Not sure why or what to do with those...

I have an Access database that pulls information from a main SQL server via append query and builds a table I use as a source for tracking purposes. The master key is the visit number since that is unique, but the problem is that the append query only adds new visits and the main database may...