ms query

Hello all. I have a situation that is driving me crazy. First off, I am using excel in Office 365. I have a workbook in which I export data out of SAS tables into different sheets. I have a main sheet where I use MS Queries to pull that data in from the other worksheets in the workbook. I...

Hi There i am new to using MS Query, i think this should be a very simple answer. I am looking to display all of the order numbers that are beginning with W, but do not include those with a '/' in the order number. I started by doing Like 'W%' which works for the first part. How do i then edit...

I am a relatively new to SQL queries and have been struggling for weeks to solve what I imagined to be a simple problem. I am using MS Query from within Excel 2016 to query the company's main database. This supports PostgreSQL - I don't know which version - only that it is unlikely to have...

Hi I have several big excel reports that pulls data from a db via MS query. (100 000+ rows in each) I use countifs formulas to show production volume based on parameters within the data. This seems like an unefficient way to do this. First of all it takes a long time for excel to process it...

I'm attempting to create a MS Query to return data from a SQL database based on a value from a cell in Excel. I have actually successful accomplished this, but only for 1 row. I cant figure out how to get it to copy-down to other rows. I've created a connection as follows: Notice that the...

This may totally be in the wrong place, but i'm using excel in this situation... kind of... I am running a query that gets all values from an access database that were recorded less than or equal to a certain date. As the sql is set up right now, he query will gather all records that are less...

I am trying to amend SQL in MS query and the error "Incorrect Syntax near the keyword AS" is being returned when I submit this code. What is wrong with the AS in this case? I've searched similar threads and tried to apply advice but still haven't managed to get it to work. Thanks in advance...

Hi, I would like to check if i want to run multiple query (eg. Jan 13 - Dec 13 different query for each month) but with different criteria (eg. Name) each time when run is it possible? Thanks.

Hello, I'm utilizing MS query in excel and can get the user to input a value in a cell and then the report refreshes for this specific criteria, say if they select North or South. However I want a report that uses this cell but brings back all data that meets that criteria, so in the example...

Hoping for a solution to this problem I have of trying to import a time into excel. I am connecting to a company server to import data using Microsoft Query. I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good...

Hoping for a solution to this problem I have of trying to import a time into excel. I am connecting to a company server to import data using Microsoft Query. I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good...

Hi, I'm using Excel 2013 (Win 7) and am using MS Query to get data from our SQL Server - just using a single table. I want to display only the records where a value in one column is the same as that in the next column. The data displayed is: AccountNo DebtorID ParentDebtorID The query is...

Hi, I have an excel .xlsm spreadsheet used for several years that has many ms query connections to an access db. After the company upgraded to Win 7 \ Office 2010 one of the simplest ms queries will not work. This query simply goes out to an access db table which contains one record and 1 field...

I am using MS Query in Excel and the query runs fine. It has parameters and is detail records. When I change the number column to be a summary instead of details, I get errors saying the: Invalid column name 'period'. Statement(s) could not be prepared. 'Period' is the name of the parameter...

I have a table of data that I have created using MS Query. This refreshes frequently when the source data is updated. I want to have two extra columns to contain data that is entered manually. However when I have tried this I have noticed that when extra rows are added to the table the manually...

I'm using MS Query to create reports that can be refreshed (Data/From Other Sources/MS Query). Once the data is pulled into Excel (2007), the column headings are those of the Safari report that I am querying. I can update the SQL code with <select field name> as <new name> but this is...

I'm having an issue that really makes you want to pull your hair out. I have constructed a query in MS Access, which executes as expected. If I use the same exact query using the MS Query method, I get a General ODBC Error if one of the parameters is a string, and works just fine if the...

Hello all, I seem to be having a problem with MS Query, as I am used to MS SQL database but am not allowed to use it. I am trying to join two queries, based on the country name being the same. I actually got it work once but I can't seem to see what I am doing wrong. I am using Excel 2010...

Hi, I apologize in advance if I am not posting in the right place, I am not sure if it this is an Access or Excel issue. I have data in Access which is imported from an ODBC Database. I have built queries in Access to handle the data, and in particular I have used the Access function...

I use MS Query extensively with data from both MS Access queries and MS Excel spreadsheets. I am currently using Excel 2010. Lately, when I refresh the query, Excel opens the source spreadsheets, even if they are tied to the Access query. This is not only annoying, it is a time-sink since I have...