23 posts tagged with access and query.
Displaying 1 through 23 of 23. Subscribe:

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 - 21 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

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

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

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

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

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

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

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

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

SQL query to get unique addresses from a list.

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

Selecting the MODE of a group of data in Microsoft Access

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

Please help with an Access/Database question!

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 - 12 answers

MySQL import question

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

How to truncate a string in Access

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 by dy on Sep 20, 2006 - 4 answers

I can't enter data into a query based on two tables in a one to many relationship.

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 by misanthropicsarah on Jul 16, 2006 - 5 answers

Now that I have torn my hair out. Whats next access?

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 by JonnyRotten on Jun 21, 2006 - 27 answers

Access Query headaches!

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 by JonnyRotten on May 27, 2006 - 23 answers

Access: making me screech since 2002.

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 - 7 answers

Querying the Database

Database Query [+] [more inside]
posted by benjh on Jan 24, 2005 - 10 answers

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

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. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers

Page: 1