The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
78 views

Trouble with DNS query using whois

What does the look them up with "=xxx" to receive a full display for each record mean? The man page does not discuss an equal sign, and I got an error when I tried to use the = literal. $ whois a.com ...
0
votes
1answer
378 views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
0
votes
2answers
1k 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 ...
1
vote
1answer
322 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
1
vote
2answers
968 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() ...
0
votes
2answers
243 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
0
votes
0answers
70 views

How to get Access 2010 query to number based on criteria from other columns

I have a query where it pulls the ID and Employee columns and I am trying to get Access to populate the data as shown in the 'OrderCol1' and 'OrderCol2' columns of the table below. As I'm sure you ...
0
votes
1answer
888 views

how to query across collections in rockmongo [closed]

If I have a collection of users and a collection of properties which has a user_id in each properties document; how do I get a list of users' and the zip codes (zip` is a field in the 'properties" ...
3
votes
3answers
50k 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 ...
0
votes
1answer
344 views

Query Execution Plan for MySQL

In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs now i want to do the same for MySQL scripts ...
0
votes
1answer
415 views

MS Access 2007 - Update query won't update

I have a Access 2007 database that I wish to be able to click a button and update Null values in a table column with the current date when the button is clicked. For some reason it just won't update. ...
1
vote
1answer
118 views

Configure DNS Rules for Hosts and Proxy?

I'm not sure if I'm approaching this problem correctly, so please correct me here. Suppose an organization runs its own DNS service. The organization wants the following: DNS queries by all hosts ...
0
votes
3answers
982 views

TFS 2010 - Cannot query certain users

We seem to have an issue with out Team Foundation Server 2010 installation that gives an error when certain users are queried. If we include them in the 'AssignedTo' filter the query instantly errors ...
2
votes
2answers
16k 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 ...
1
vote
1answer
617 views

VB script or command line instruction to query a modem connected to my PC

Is there any vb script to query a modem that is connected to one of the ports of my machine?How can I query my modem from command prompt?
1
vote
1answer
172 views

Filtering field on view - Lotus 8.5

I have one view with field that I called "Date". I can┬┤t filter the results for one date... please help me.
0
votes
0answers
145 views

Network goes “Request Timed Out” when I run a query

I use postgreSQL 9.2 as the database and Java 6 as the programming language. There is no problem when I run my program on the server computer. But when I run my program from a remote client, ...
1
vote
2answers
6k 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 ...
3
votes
2answers
2k views

Foobar2000: any way to query whether a song is in a specific playlist?

In Foobar2000, I would like to make an autoplaylist that only shows songs that are not currently in another specific (manual) playlist. Is there any way to query for this? I imagine the query to ...
0
votes
2answers
1k views

Is it possible to put a wildcard search into a parameter query in LibreOffice Base?

I am using Base in LibreOffice 4.0 (still using the HSQL that comes with Base but looking at moving to HSQL 2.2.8) and I would like to do a query that asks for parameter input like: SELECT * FROM "...
0
votes
1answer
1k views

Simple fixes for improving multi-user MS Access performance?

I'm overhauling the entire IT infrastructure for a small office. They had a Dell T410 doing nothing but serving as a Win2k8 file share, so I figured I could replicate its functionality on an unused ...
1
vote
1answer
196 views

Exporting an SC query result to Excel

I wrote an SC query to show all the services and their state and I can easily display it in a text file. What I want to do is list all this data directly to an Excel worksheet. How / is this ...
1
vote
0answers
409 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
1answer
97 views

excel / open office - append an incrementing value to all non-unique fields

I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example: store_1 store_2 etc. Anyone know how to ...
28
votes
1answer
14k views

Does an anchor tag come before the query string or after?

I am unclear if an anchor tag should come before a query string or after. http://www.domain.com/search?query=hello#name or http://www.domain.com/search#name?query=hello Or does it matter?
0
votes
1answer
288 views

Upgrading from built-in Windows 7 32-bit to 64-bit? [duplicate]

Possible Duplicate: Windows 7 and Vista Activation FAQ: How do language, version, 64-bit or 32-bit, and source affect ability to install and transfer Windows licenses? Recently my hard drive ...
0
votes
1answer
156 views

Does MS Access update the data on the clipboard from a query when the data in the database changes?

I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...
1
vote
1answer
832 views

Query data in Powerpoint

I would like to build an MS PowerPoint 2010 presentation where some of the displayed data would be queried from an external source (I am flexible - the simpler the better, I need to update that ...
0
votes
3answers
783 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 ...
1
vote
1answer
4k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
0
votes
1answer
5k 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
1answer
786 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. ...
2
votes
1answer
1k 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
1answer
1k 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
2k 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 ...
0
votes
2answers
816 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?
0
votes
1answer
1k 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 ...
1
vote
1answer
419 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.
4
votes
2answers
5k 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
40 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
522 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?