How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted on Jan 25, 2008 - 8 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 on Apr 18, 2007 - 9 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 on Dec 13, 2006 - 3 answers

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 on Nov 18, 2006 - 12 answers

What is the easiest way to get this data into a MySQL database? [more inside]
posted on Nov 2, 2006 - 19 answers

I'm writing an query in MS Access to get column 1 = product ID, column 2 = product Description. However, the description field has addtional spec data that I don't need. I want to remove anything after the first word, meaning remove after the first blank space. Example: Prod ID      Prod Desc 10-362-3     Packing DT 12-345-5     Seal XT L-23 Desired result: 10-362-3     Packing 12-345-5     Seal I tried to use FIND or SEARCH functions to identify the position of the first blank space and to truncate everything after that. However, Access does not recoganize either FIND or SEARCH. Does anyone have any idea how to accomplish this? Thanks.
posted on Sep 20, 2006 - 4 answers

I have two tables in access, linked by a one to many relationship. I've made a query that pulls the information I want from both tables into one place. But now I can't type any data into the query or the form I made based on the query. Why not? [more inside]
posted on Jul 16, 2006 - 5 answers

Yet another Access Query Question. Similar to my other question, but even more frustrating. I need to craft a query that will tally values across many fields and entries. [more inside]
posted on Jun 21, 2006 - 27 answers

I have a access query that is making me tear my hair out. My database has 40 fields that have three possible values (OK, NG, NA). I need to list only the entries that have NG in any one of those 40 fields. [more inside]
posted on May 27, 2006 - 23 answers

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 on May 2, 2006 - 7 answers

Database Query [+]
posted on Jan 24, 2005 - 11 answers

Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
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.
posted on Apr 17, 2004 - 15 answers