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 -
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 -
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 -
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 -
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.
posted by noway
on Mar 22, 2010 -
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 -
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 -
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 -
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 -
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 -
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 -
Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted by dance
on Nov 18, 2006 -
Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
posted by By The Grace of God
on May 2, 2006 -
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports. [more inside]
posted by nomisxid
on Feb 15, 2006 -
Say I have a database
there is a table called
In this table is a field named
. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]
posted by Grod
on Apr 17, 2004 -