The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
319 views

Matching similar records in a database with Group By

I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this: Company Name ...
1
vote
2answers
635 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
2answers
35 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
2answers
420 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
2answers
680 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
24 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
1answer
70 views

Access Query for Positive Checkboxes

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc. Say for example i wanted ...
1
vote
1answer
120 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
1answer
95 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
0
votes
1answer
130 views

wget - Double downloads with query strings in URLs

I have to use wget to download, with the recursive option (-r), all the files in a web page. This page contains N direct links to the N files (http://xxx.xxx.xxx.xxx/page/File_n.abc), but also ...
0
votes
1answer
65 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
181 views

Creating pivot tables from multiple worksheets with power query, how to copy query for 20 workbooks?

I have 20 different workbooks, each with 12 sheets (Jan-Dec). I need to summarize certian data from each workbook, spliting quartly results. It is a sales log for 20 locations, with each sales person ...
0
votes
1answer
39 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 ...
1
vote
0answers
211 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 ...
0
votes
0answers
14 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
0answers
12 views

In Access, how can I reset the AutoNumber field as new data is deleted/appended?

Essentially what I have is a temporary table which logs data through an append query. This table is used to store consecutive strings of data, that will be exported to a .csv eventually. What I'm ...
0
votes
0answers
22 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
0answers
42 views

WQL for getting systems where last logon user is particular value for 'office' attribute

I need to make a membership rule for a device collection in System Center Configuration Manager 2012 R2, using WQL. I want to get all the devices where the last logon user has a given value for the ...
0
votes
0answers
114 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
91 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
0answers
422 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?