The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
11 views

How to replace hidden elements in access?

I work with MS-Access database with a lot of tables, qureys and reports. It is easy to hidden some elements (by right mouse click then hidden options), but I do not fin the option to replace those ...
0
votes
1answer
73 views

How to share Power Query queries

I was looking for a way to share Power Query queries. I am not sure on how to share query in the intranet. Seems like sharing in Power Query Data Catalog is named "Power BI Data Catalog". This is ...
0
votes
1answer
32 views

update multiple fields in SQL

I am trying to update my table in SQL 2012 where the CategoryNumber values should be correspondant for the below name values but it seems that my syntax is wrong. Update mytable SET mytable....
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
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" ...
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 ...
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
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 ...
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. ...
0
votes
0answers
14 views

Query to create a matrix of values from one Column [on hold]

I'm new to SQL and I have a very tough task on hand. I have a data set of about 50000 records that looks like this. Header Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8 Value 9 ...
0
votes
0answers
9 views

How to only modify data in table of microsoft access through update queries

I am quite new to Microsoft Access and would appreciate if someone can help me with this. I would like to modify data in table of microsoft access through update queries only but also prevent the ...
0
votes
0answers
13 views

Access Query Save Path Error

I am trying to save an Access query with a certain path (which i can't modify) but i am getting a save error. The save path looks like this : "C:/FOO/BAR/03. FOO/BAR.accdb" Testing the path i found ...
0
votes
0answers
24 views

How to tell if multiple sites contain a keyword

I have a list of 9k web addresses, and a couple of keywords. I would like to know if a webpage contains that word. Ideally, automated google search with some search operators would work great, for ...
0
votes
0answers
37 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
1answer
18 views

Nested IFF query in MSAccess returning wrong number of arguments

I am trying to write a nested IFF query in MSAccess, but on running the error returned is "Wrong number of arguments" My two fields Paper1 and Paper2 are of datatype True/False The Query I wrote in ...
0
votes
0answers
8 views

excel vs access query priority

Hi Superuser this is my question Scenario: -an Access 2003 based application to manage the stock; the application had several mask to peform the update of different .mdb table. -an Excel 2003 ...
0
votes
0answers
13 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, I know that optimization for any query is happening inside the DBMS with using of system catalogs which contain ...
0
votes
0answers
40 views

Web Query with login details

I want to create a web query with that will add info like (Account used, username (emails), password) I created a web query already. Please find below the code. My problem is the fact that I have 5 ...
0
votes
0answers
18 views

Dynamic Web query in excel

What i need to have is an excel that can take data from a certain website based on the info i write to a cell in that excel. to be more clear, in the website "Gcmap" when i search "jfk-lax" it gives ...
0
votes
0answers
77 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
0
votes
0answers
13 views

Running SPARQL queries via Atom

Using Sublime SPARQL Runner is possible to directly run SPARQL queries. I'm looking to fin a similar solution for Atom. I see that there is some interest in this as the language-sparql provides some ...
0
votes
0answers
62 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
0
votes
1answer
92 views

Can I query a different AD domain with the default Win7 install? [duplicate]

Background I work in an Enterprise where our Active Directory is locked down pretty tight and only Info Security has access to administer changes. I'm using a standard Win7 Enterprise x64 Service ...
0
votes
0answers
18 views

MySQL Query to Find Distinct Instance of Status

My question is regarding a MySQL query that I am trying to write. I have written some psuedo-code to help illustrate what query I am trying to write: SELECT * FROM persons AS p INNER JOIN ...
0
votes
0answers
35 views

Alternative option for select * from

In the Excel database query we will use the below syntax to define a reference value SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT' In the above case I am taking the Dept value IT as a reference ...
0
votes
1answer
188 views

XML query of event log not working

I have been looking for a query to act as a trigger in the Task Scheduler. I want to restart my VPN if it RASClient ends (EventID 20226) for any reason except code 631 (The port was closed by the user)...
0
votes
0answers
19 views

Query Concatenation

I need to concatenate 5 fields together. Now the problem is field field2 could have data but not field1 which gives me a headache of extra white space at the beginning and an un-necessary comma if I ...
0
votes
0answers
31 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
0
votes
1answer
64 views

OpenLDAP parametrized replication of a subset

I have a huge LDAP database and I'd like to make a replica that contains only a subset of that database. My objective is to replicate a few groups, and all members within that group. So far, I'm ...
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
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. ...
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
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, ...
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
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?
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
votes
2answers
162 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.
-1
votes
0answers
17 views

Switching Techniques - Vlan

Assume I have 3 switch connected to each other and port connected to each other are in trunking mode and sw1 have a user in vlan 10 and sw3 has a user in vlan 20. How can both user (which are in vlan ...