The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
45 views

Web queries have slowed down after updating Excel 2003 to 2010

I built an excel workbook in windows XP. Using excel 2003. I have moved the file to excel 2010 on Windows 7 enterprise. The workbook has about 20 web queries. I had no problems in the earlier ...
0
votes
0answers
112 views

MS Access 2010 Query Linked to a SQL 2008 database do INSERT to table in MS Access file

We have about a dozen inherited Access programs written 10-12 years ago. The author is not here now. We are having to add functionality to the Access code. I have never developed in Access. I am ...
0
votes
0answers
22 views

How to split long Google searches and combine them later?

I have a list of keywords, which change regularly. I would like to search Google for new occurrences of pairs of these keywords. keyword1, keyword2 keyword1, keyword3 I can construct a query ...
0
votes
2answers
113 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
47 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
192 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. ...
0
votes
1answer
206 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
0answers
106 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, ...
0
votes
2answers
715 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
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
457 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?
0
votes
2answers
837 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
votes
1answer
190 views

Is there a tool or website to generate DNS query packets for looking up the IP address of a hostname?

Is there a tool or web site where I can plug in some values and have it generate the bytes for a DNS query to look up the IP address of a hostname? Preferably one where it explains how the values ...