Join 3,551 readers in helping fund MetaFilter (Hide)

76 posts tagged with query. (View popular tags)
Displaying 1 through 50 of 76. Subscribe:

Related tags:
+ (34)
+ (24)
+ (23)
+ (16)
+ (13)
+ (6)
+ (5)
+ (4)


Users that often use this tag:
desjardins (7)
CollectiveMind (2)
omnipotentq (2)
maxwelton (2)
JonnyRotten (2)
Jimbob (2)

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

Good free (or really cheap) system to poll an audience while lecturing?

Does anyone know of a good site or software that is free or cheap that lets you: 1) Ask a poll or multiple choice question during lecture and, perhaps, in the next slide, populate a graph with the results? Again, thanks in advance for any good links here. [more inside]
posted by skepticallypleased on Jul 16, 2013 - 7 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

Fixing an unreasonably slow MySQL query

Query and Explain output here. Query must be executed 4022 times, each with a different Strip_ID, while the script processes, adding 4+ minutes to what would otherwise be a ~90-second task. I have (separate) indices defined @ Parent_Table and Parent_ID, in addition to the table's primary key on an auto-incrementing ID. Adding combined indices for those two fields (in each order, just to be safe) did not change MySQL's analysis of the query or improve execution speed. [more inside]
posted by The Confessor on May 24, 2013 - 9 answers

Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
posted by jeather on Apr 18, 2012 - 2 answers

Better Living Through Queries

Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
posted by bluejayway on Mar 1, 2012 - 11 answers

How do I get the old Google search results back?

So, it would appear that Google have changed their search algorithms. Using search queries that would have previously returned hundreds of results I am getting a handful of results which are mostly irrelevant / gibberish. Any ideas how I can go back to the "old" Google? Thanks!
posted by FuckingAwesome on Mar 1, 2012 - 14 answers

Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus on Feb 22, 2012 - 8 answers

Is there a way to visually organize database tables (and saved queries and views)?

I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
posted by iamkimiam on Feb 2, 2012 - 4 answers

Editorial Calendars, Yes or No

I am doing some freelance writing and have a program that helps organize publications, their contact information and my writing history with them. Querying editors works but has a low success rate - probably about 5% of queries result in assignments ... that is, no speculation pieces. I research the publication and tailor specific queiries to specific subjects, so editors know I'm not mass querying similar publications with the same topic. Many publications use editorial calenders to preview what they're going to feature months in advance [more inside]
posted by CollectiveMind on Oct 2, 2011 - 3 answers

How to write an SQL query in unix?

I'd like to perform an SQL query with outer joins, from text files on my PC, using only a unix emulator. Is this possible on my PC? How would I write and execute it? [more inside]
posted by RobinFiveWords on Sep 13, 2011 - 16 answers

How do I get data from multiple other entries in a database?

SQL help: I'm very new to SQL, and need to update one field with the maximum value of all entries in another field selected based on a shared value in a third field. [more inside]
posted by agentofselection on Jul 17, 2011 - 12 answers

methods or products to query objects?

What are some "end user" products (preferably open source) or methodologies that allow complex queries of objects? I want to allow both programmers and non-programmers to be able to access the data. [more inside]
posted by santogold on May 20, 2011 - 10 answers

TF2 server queries?

Is there a way to tell what specific mods a Team Fortress 2 server is running from the client console? [more inside]
posted by ofcourseican on May 2, 2011 - 1 answer

Need help with SQL statement

I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need. [more inside]
posted by desjardins on Jan 26, 2011 - 7 answers

I want to query a map like a database!

I'd like to query geographical and population-based data. "$city <> 200,000" and so on and so forth. What is this called and where can I find data like this? Willing to spend some money if necessary. [more inside]
posted by unixrat on Jan 19, 2011 - 8 answers

How do I append rows to a table in Access from two related tables?

How do I append rows to a table in Access from two related tables? [more inside]
posted by desjardins on Dec 27, 2010 - 3 answers

Need help formatting an Access report from a query and SQL help

I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front. [more inside]
posted by desjardins on Dec 20, 2010 - 4 answers

I haven't needed SQL this ugly before

What SQL magic do I need to turn one column into several? [more inside]
posted by flabdablet on Dec 19, 2010 - 14 answers

How can I select this in SQL?

SQLfilter: Help me solve a problem that's driving me crazy. I'm working with someone else's data, and I've got a seemingly insurmountable select problem that no amount of googling has helped me with so far. [more inside]
posted by Mr. Bad Example on Dec 17, 2010 - 11 answers

Automatically generating an email from a query in Access

I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
posted by desjardins on Dec 10, 2010 - 8 answers

MySQL: How to Selectively Update a Table from a CSV List?

MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
posted by darth_tedious on Nov 18, 2010 - 8 answers

mySql query assistance, please!

mySQL query question about calculating percentages in a table. [more inside]
posted by omnipotentq on Sep 5, 2010 - 3 answers

All your data are belong to CURL

Where can I lookup the future earnings reports date of a given company by ticker. [more inside]
posted by sourbrew on Aug 1, 2010 - 5 answers

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

$700 on the publishing industry roulette wheel...

I have written a literary science fiction novel. I am confident that it is salable, but I am so far having difficulty finding an agent. I am considering going to the Backspace Writer's Conference but am uncertain as to whether the $700 cost would be a good investment. [more inside]
posted by 256 on May 2, 2010 - 12 answers

using a QUERY formulate in Google Spreadsheet

Hi, I searched through the archives and did not find a match. Thank you in advance. Let's say I have a spreadsheet in Google docs with two columns, names and dollar amounts. Jane Smith, $5; Joe Sixpack, $7; Jane Goodall, $4; Joe Frankin, $10, etc. I want to use – I think – the QUERY function to ADD up all the dollars that all the Joe's have, or all the dollars that the Jane's have. I have read through as much documentation as I can find and it's not giving me enough to formulate a successful query. This:
=query(A1:B20, "Select A where (A contains 'jane')", sum(B))
does not work. Any suggestions? thank you!
posted by noway on Mar 22, 2010 - 11 answers

SQL QUERY ow to achieve it? (short paths)

I am trying to create a SQL Query for Access2003 that will basically show me by employee ALL potential classes they can take and sorted together with the most recent date of a class they may have taken. Basically this is used as a worksheet to plan training for the people who may have some of the required training but not others. (see inside [more inside]
posted by wildpetals on Feb 2, 2010 - 3 answers

No Reply re: short story status! What next?

How do I query literary periodicals about "disappeared" short stories? [more inside]
posted by uans on Jan 22, 2010 - 11 answers

Uh...hang on, just give me a minute.

What is the most important scientific question of our time? [more inside]
posted by Demogorgon on Oct 12, 2009 - 44 answers

Query email format?

Should I maintain double spacing in an agent query email? Submission guidelines ask for the first 5 pages of my manuscript. How faithful should I be to the actual document? [more inside]
posted by bobbyno on Sep 17, 2009 - 4 answers

Movie producers keep asking about my article

Screenplay question. [more inside]
posted by anonymous on Sep 4, 2009 - 11 answers

How to Submit Query to Magazine?

How does one submit a professional query to a national magazine? [more inside]
posted by goalyeehah on Jul 22, 2009 - 5 answers

There's got to be a faster way to update

Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

How do I put a wildcard into the truepart of an IIf statement of an access query criteria?

How do I put a wildcard into the truepart of an IIf statement of an MS Access 2003 query criteria? [more inside]
posted by JeremiahBritt on Feb 11, 2009 - 9 answers

Comparing two similar but non-matching tables in Access?

Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years. [more inside]
posted by dnash on Feb 5, 2009 - 13 answers

How do I produce an inventory of my data in MySQL?

What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
posted by crapmatic on Dec 10, 2008 - 5 answers

How to safely get an endorsement?

OK, I've posted on this subject before. Each time, I'm a little further along. Here is where I am right now. I've been working on a book since March. The idea upon which the book is based has been getting a lot of attention recently and has consistently been in the news for about four years. [more inside]
posted by CollectiveMind on Dec 8, 2008 - 5 answers

What are some funny "related searches"?

I'm trying to come up with humorous examples of search engines making query suggestions. For example, Google might suggest "how to cook a baby" when you search for "baby". I've seen some posted around the internet before, but can't seem to find them now. Does anyone have such links/examples? They don't have to be currently working examples.
posted by lpctstr; on Nov 29, 2008 - 15 answers

Indexing a SQL table for efficient queries

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

Need help with a SQL query

I've got what should be an uber-simple SQL question.... [more inside]
posted by omnipotentq on Jul 7, 2008 - 8 answers

Using the word count (wd) in Gale PowerSearch

Librarians / Researchers / Gale PowerSearch users/developers! How do I use the word count limit successfully? [more inside]
posted by hobbes on May 9, 2008 - 2 answers

SQL and mail merge help needed in Access 2007

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted by desjardins on Apr 11, 2008 - 6 answers

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

Using Windows to query Unix RPC

Using Windows to query Unix RPC rquota? [more inside]
posted by lundman on Mar 10, 2008 - 7 answers

What is the right combination of joins and select statements to get this information from a mysql database?

MYSQL newbie needs some help with a crazy query! (Joins, foreign keys, and bears "oh my!") [more inside]
posted by lucidreamstate on Feb 25, 2008 - 4 answers

How to count the number of times a string appears in a database field.

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers

How to run a query in Excel 2007?

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted by desjardins on Jan 25, 2008 - 8 answers

Cancel a SQL Server Query

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted by smithygreg on Nov 29, 2007 - 3 answers

Open source web framework/document management system?

I'm looking for something sorta like plone or drupal, but that supports structured documents (e.g. per an XML DOM or something similar) and allows for component-wise searching of those documents. [more inside]
posted by badstone on Oct 11, 2007 - 2 answers

Page: 1 2