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]
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]
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]
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]
Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
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!
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]
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]
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]
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]
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]
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]
Is there a way to tell what specific mods a Team Fortress 2 server is running from the client console? [more inside]
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]
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]
How do I append rows to a table in Access from two related tables? [more inside]
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]
What SQL magic do I need to turn one column into several? [more inside]
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]
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]
MySQL: How Do I Selectively Update a Table from a CSV List? [more inside]
mySQL query question about calculating percentages in a table. [more inside]
Where can I lookup the future earnings reports date of a given company by ticker. [more inside]
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
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]
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.
=query(A1:B20, "Select A where (A contains 'jane')", sum(B))
does not work.
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]
How do I query literary periodicals about "disappeared" short stories? [more inside]
What is the most important scientific question of our time? [more inside]
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]
Screenplay question. [more inside]
How does one submit a professional query to a national magazine? [more inside]
Please help me simplify a complicated mysql update [more inside]
How do I put a wildcard into the truepart of an IIf statement of an MS Access 2003 query criteria? [more inside]
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]
What kind of MySQL query should I use to inventory this table? Details inside... [more inside]
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]
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.
I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
I've got what should be an uber-simple SQL question.... [more inside]
Librarians / Researchers / Gale PowerSearch users/developers! How do I use the word count limit successfully? [more inside]
I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
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]
Using Windows to query Unix RPC rquota? [more inside]
MYSQL newbie needs some help with a crazy query! (Joins, foreign keys, and bears "oh my!") [more inside]
SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
Please help me understand what happens when I click the cancel query button in SQL Server Management Studio.
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]