Search results

I have connected to a SQL Server Db and pulled in all the "tables". The problem is that some of the "table" are actually SQL views. How can I use the Linked table GUI to ull in only actual SQL tables and exclude the SQL views? It seems that the ODBC connector tool treats a SQL view and SQL...

A client has decided to retroactively change the unit of measure field in his ERP database. :eek: I need to do a mass update to the entire database to change the old unit of measure to the new one. The problem is that the field "UoM" is actually stored in a multitude of ways. In different tables...

I am writing a query to calculate commissions. The query is built except for the commission rate and commission calculation. The issue is that the commission rate is not stored anywhere in another table and the rule is dependent on more than one variable. The rule, in English, is as follows...

I have an Access Db where I am pulling in (via ODBC/USQL) linked tables to an ERP system (C-ISAM). I would like to be able to convert the linked tables to regular tables. The only way I know how to do this is to run a make table query for each individual linked table. There are several...

I am rather new to Access so please forgive if this question is simplistic. I have a new client for whom I am writing some queries for. The source Db is ISAM. I installed a USQL license, created a DSN, and pulled the data into Access via ODBC linked tables. I only have time to go out to the...