The query tag has no wiki summary.
0
votes
0answers
12 views
Query 1 field using 2 field for where clause [migrated]
i have table like this :
Column | Type | Modifiers
---------------+-----------------------------+-----------
id | smallint | not null
...
0
votes
1answer
27 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
77 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
265 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
69 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
130 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
173 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
84 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
236 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
146 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
55 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
118 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
732 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
473 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 | ...
0
votes
0answers
128 views
How do I add an autonumber field in a query in Access?
I have an employee database that I'm trying to connect to an org chart. I want the org chart to pull data from a query, and I want the chart to update automatically as I update the database. I need to ...
1
vote
2answers
227 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
0answers
70 views
Using wildcards when querying terminal servers with batch files
Here's my situation. I have several offices that log onto servers with different logins (examples: B9999csr or b9999dispatcher). What I'm wanting to do is be able to search for all users that start ...
0
votes
1answer
36 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
193 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?
3
votes
1answer
4k 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
169 views
Complex Google queries get IP banned? [closed]
I wondered if anybody might be able to try this query (or a similar) on Google:
(Intitle:"vacancies" OR inurl:"vacancies" OR Intitle:"join our team" OR Intitle:"work for us") -agency -recruitment ...
1
vote
2answers
131 views
How to turn off Google's automatic query term 'corrections'? [closed]
Is there a way to tell Google not to replace my original keywords by other, similar words? It quietly assumes a misspelling in my query:
r filter sapply
and shows documents with
r filter supply
...
0
votes
1answer
76 views
Graphical Decision Engine Framework - Any ideas?
I'd be soooo grateful if anyone could let me know if they are aware of an open-source decision framework I could use? Let me explain further:
What I am looking to create is some kind of graphical ...
1
vote
2answers
528 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
482 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
327 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
382 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
12k 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
2k 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 ...