The query tag has no wiki summary.
0
votes
0answers
15 views
MS Query launched from Excel 2007 stays minimized to task bar [closed]
Possible Duplicate:
MS Query unresponsive after launching in Excel 2007
I am trying to assist a user who is launching MS Query from Excel 2007, MS Query then launches but stays minimized to ...
0
votes
1answer
54 views
How can I get autocomplete to work (with a keyboard shortcut) with Sequel Pro?
If I type in a table name or part of a table name and wait a few seconds, a popup box will show up and allow me to choose a table or column. Is there a way to get this box to pop up without waiting - ...
2
votes
1answer
147 views
How do I get Excel to run a query for each row in a spreadsheet?
Is there a way to run an MS Query for each row in a spreadsheet? For example, I have a sheet that looks like this:
CustomerID
111
222
333
I have the customer's address in a database, and I'd like ...
1
vote
2answers
784 views
Querying against Active Directory
I'm the "script guy" at my work, which is a blessing and a curse... I've been tasked with generating a script of:
Can you create a script to pull all users that have a proxy address
that is not ...
1
vote
1answer
146 views
Where is a Web Query stored in an excel file?
I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table.
In an Excel Web Query you are ...
2
votes
1answer
304 views
Embed microsoft query in excel with multiple parameters from spreadsheet
I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
1
vote
1answer
325 views
Access 2007 create report from query
Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me ...
0
votes
2answers
119 views
Is there a way to query file names in a directory within Access 2010?
Is there a native function for this within Access? Or would I have to do this with a batch script somehow?
Moreover, could I rename the files in a directory based on fields in an Access table?
1
vote
2answers
810 views
Pass a cell contents as a parameter to an excel query in Excel 2007
I have tried really hard to solve this issue but I think I am going to need a little help. I can program in different languages but I don't have any experience with Excel, VBA or the queries you can ...
0
votes
1answer
254 views
Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?
I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.?
The query has the globe to the left of ...
0
votes
2answers
69 views
SQL/DB browser for DB2
I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
0
votes
1answer
147 views
Query dpkg for All Packages Installed/Removed from Default Image
Is there any way to query dpkg to tell what packages have been added/removed since the base install of a system?
I am running Debian 5.
3
votes
2answers
1k views
Pass parameter from Excel to Access query
I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...
0
votes
1answer
1k views
Combine fields from multiple tables in Access query
As an example, I have two queries in Access. The first outputs two columns:
| Cust ID | Revenue 1 |
| A | 5 |
| B | 10 |
The second query is similar:
| Cust ID | ...
1
vote
2answers
280 views
Separate tables or single table with queries?
I'm making an employee information database. I need to handle employees that are separated from the company. Should I a. set up a query with a macro to send separated employees to a separate table, or ...
0
votes
1answer
38 views
Managing records of bugs and notes
I want to create a knowledgebase for a piece of software. I'd also like to be able to track bugs and common points of failure in that application. Linking knowledgebase articles to bug records would ...
0
votes
0answers
245 views
Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today
I'd like to use Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today. Is there reserved name that I can use, like TODAY-30 under the filter criteria?
5
votes
1answer
8k views
Run an SQL Query With a Parameter from Excel 2007
I have a query in an excel table. I followed this to do it.
But how can I add a parameter from a cell into my query?
I am looking for a way to do this
select *
from dbo.Customers
where CustomerID ...
0
votes
1answer
88 views
Graphical Decision Engine Framework - Any ideas?
Is there an open-source decision framework I could use?
What I am looking to create is some kind of graphical interface to allow people to visually build a query based on a set of parameters, ie. ...
1
vote
2answers
586 views
SQL Server Management Studio Express - include date/time in Results or Messages
In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows?
(without having to manually add a SELECT Getdate() ...
1
vote
2answers
570 views
Light-weight, free, database query tool for Windows?
My question is very similar to the one here except pertaining to a Windows tool. I am also referencing this table and what I found here with a Google search. However, I have no idea which tool would ...
0
votes
2answers
381 views
Return cell reference as result of if statement with vlookups
I have two sets of data in excel. One contains a set of data which represents the initial step of a process. The other set of data represents the additional steps which take place after the first ...
0
votes
3answers
504 views
Free Database Utilities / Tools for Mac OS X
If I were using Windows and wanted to use a database I would set up a WAMP server.
What can I use for Mac OS X?
I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite.
I would ...
3
votes
3answers
16k views
Merge multiple columns into one via a query in an access database
i need to write a query that combines multiple columns of text.
my database is a database of wallpapers on my computer (i use john's background switcher), so i can easily find them and have them ...
12
votes
9answers
3k views
Querying a CSV file
Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use.
I know I could write a small ...
