The tag has no usage guidance.

learn more… | top users | synonyms

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
867 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
49k 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
320 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
398 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
117 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
953 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
15k 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
594 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
160 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
144 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
991 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
194 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
397 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
96 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 ...
26
votes
1answer
13k 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
287 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 ...
0
votes
1answer
154 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
818 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
780 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
3k 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
746 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
798 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
2answers
148 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
981 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
417 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
510 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?