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
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
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 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
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
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
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
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
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
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
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'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
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
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
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
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
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
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
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
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
How do I query literary periodicals about "disappeared" short stories?
[more inside]
posted by uans
on Jan 22, 2010 -
11 answers
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
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
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
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
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
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
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 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
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
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
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
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label.
[more inside]
posted by odinsdream
on Apr 18, 2007 -
9 answers
Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help.
[more inside]
posted by thanotopsis
on Jan 31, 2007 -
20 answers
How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table?
[more inside]
posted by apark
on Jan 24, 2007 -
5 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the
mode of the values that it's grouping, when I want averages in other multiple fields?
[more inside]
posted by Jimbob
on Dec 13, 2006 -
3 answers
