Search results

Hi, I understand this information is like bread and butter (basics) for some, but I don't want to make any mistakes so I'd rather ask for support and thank you in advance for your time. I have linked tables from SQL Server using ODBC connection that their location never changes. I have used...

Hi, I am working on an MSACCESS database that reads data from SQL Server through ODBC Connection. I have multiple tables that I have linked in and created Queries that read the data and created Make Table query. However, I am asking if there's a way to bring the data through a query that...

HI, I am having an issue with a select query as I want one column to show the MAX and "00" value of the same Column. How do I go about having this task completed. Any help is greatly apprecaited For example, the column has 00,01,02,03,04,05,*1,*2,*3,*4,*5 so I want a query that will help me...

Hi, I am in need of consultation for MS Access reading data from ODBC connection. I have SQL Server that has all the data for the project financials etc. I need a database that will read only certain data from the tables, for example, I don't need to import all 500,000 lines from SQL through...