I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this:
The table has many, many values between about 1900 and today. I would like to make a table like this:
1900 - 1909 23.6
1910 - 1919 64.3
1920 - 1929 73.1
Again, I'm using Access 2010. Any help would be massively appreciated.
posted by rybreadmed
on Aug 1, 2014 -
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 -
At work, I have been deemed the person in my group who should learn Microsoft Access. I am allowed to take a class. Can anyone recommend a good Microsoft Access class in NYC? [more inside]
posted by millipede
on Jun 18, 2014 -
Recently my girlfriend switched internet providers, from Verizon to Time Warner. Since installing the new Time Warner-provided router, we've both been having problems with our phones seemingly not being able to use certain apps or services. [more inside]
posted by Venadium
on Jun 11, 2014 -
VBA and Macros and VLookup, Oh My!
I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start.
Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago
on May 19, 2014 -
I'm heading into the Army for OCS in August, but I'm still very interested in keeping current on science and the current research papers. I've devised a contrivance to keep myself plugged in and reading - a personal blog where I summarize the papers that interest me, more simply to give me a place and a reason to do it. [more inside]
posted by Punkey
on Mar 23, 2014 -
I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field. [more inside]
posted by tsh
on Feb 24, 2014 -
Lately when I turn on my Mac, it detects an Airport Extreme base station. I don't know where the station is; I don't have one and I don't know the password to the one being detected. The Airport Extreme is chosen instead of my home network for internet access, and even when I manually cancel it and choose my own network, I sometimes lose connectivity as the computer returns to the Airport Extreme as a default connection. Lately, this is also happening with a PC and a Kindle, making it hard on all devices to choose my home network and keep it as a default.
posted by layceepee
on Feb 15, 2014 -
I just moved into my first multistory home. Time Warner Cable installed their wifi modem on our second floor, and we have a very weak wifi signal in our (finished) basement. I'd like to know how to boost our wireless signal with minimal sacrifice of bandwidth/speed, and without having to have TWC come in again and move our modem to the first floor. Details within. [more inside]
posted by zarq
on Feb 15, 2014 -
I have thousands of rich text message message fields currently formatted in RTF (rich text format) that need to be stripped of their formatting and converted to plain text. Currently the field is in a Microsoft Access database. But if needed, the database could be sent to Excel if that would ease the conversion of the RTF to plain text. [more inside]
posted by Jackie_Treehorn
on Nov 12, 2013 -
I receive timetabling data in Excel spreadsheets and want to map it out automatically, rather than working out the timetable/grid by hand every time because the data changes, and I'd also like to filter it to show certain groups - teacher for example. [more inside]
posted by b33j
on Oct 14, 2013 -
Is there a good Access training option where you learn it by working in the program interactively rather than just watching videos or reading text?
posted by ewiley28
on Jul 25, 2013 -
We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira
on Jul 17, 2013 -
Asking for a friend: Despite not having changed hard- or software, my friend can't access a website that is up and running normally. He can access it (and his account) from other locations (i.e. friend's place), just not from home. What's going on and how does he fix it? [more inside]
posted by MinusCelsius
on Jul 8, 2013 -
I am working on a list since 2004 that I think would be salable. It's publicly available contact information for radio, TV, magazines, syndicates, newspapers, book publishers and agents. I'm a freelancer and I originally started it because I wanted to be able to reach these sources to interest them in my content. But I realized it could be a product. [more inside]
posted by CollectiveMind
on Jun 27, 2013 -
I will be renting a cabin in a remote area in the US (mountains outside of Asheville, NC) and need to have internet access from my laptop for one day. I looked at maps of coverage and it seems like only 1 local carrier has a nearby tower. What are my options? (more inside) [more inside]
posted by NikitaNikita
on Jun 20, 2013 -
We will be needing to drive an elderly relative to various locations over the next few months to help her find and relocate into a new retirement home.. She has had extensive spine surgery and is unable to life either foot up more than about one inch and maybe not even that.
I have been looking for a temporary device (under $100.00) that we can use on these occasions but have no idea what to look for. She uses a walker - refuses a wheelchair.
She's tried the "bottom in first" then swinging her feet in but that still involves lifting them. She used to be able to do that but no more.
Maybe the only solution is to get a cab with sliding doors that opens down on the street level and she follow behind us in the cab but that would be expensive and time consuming as we would have to have the cab wait while she is inside being interviewed, taken on inspection, etc.
posted by Tullyogallaghan
on Jun 18, 2013 -
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 -
Is there a simple way to assign a keyboard shortcut to a macro in Access 2007? I understand that macros behave differently in Access than they do in Excel (which I'm more familiar with). I have written a sub called "ImportAll" in Module1. I'd like it to run when I push Ctrl+I. How would I go about achieving this?
posted by Proginoskes
on May 10, 2013 -
I have read that John Walkenbach's books are the de-facto standard for learning to use VBA in Microsoft Excel. I'd like to know what books are recommended to learn to use vba in other Office products - primarily Access, but also Word and Powerpoint. I'm more interested in books than in websites.
posted by Proginoskes
on Apr 6, 2013 -
Ok, I have an application that is using a back end of MS Access...I have another application that needs to get some of the data in the Access db but it is only SQL compatible.
So...how do I set up an ODBC connection that will pull data from the Access db and write it out to a SQL db? This data needs to be updated hourly...
Thanks for your assistance!
posted by keep it tight
on Mar 14, 2013 -
I do some developery-type stuff at work and the more complicated it gets, the less organized I am. I often find myself wondering why I did this or that or what I was trying to accomplish with it. I reuse a lot of the same functions and bits of code but I don't have a good system of keeping track of them. I know about commenting within code, and I do that, but I'm looking for a larger system of general best practices more than a specific solution. [more inside]
posted by desjardins
on Mar 12, 2013 -
My Wife and our 1 year old and I are about to embark on a 3 leg trip. I'm after generic airport/airline tips for babies but I have a few specific things to address. [more inside]
posted by Admira
on Mar 4, 2013 -
Everything I do, all day, every day, hurts. The more I do things that are painful, the more the pain snowballs. We're going to build a house that we hope will help reduce the accumulation of pain, and maybe even let me recover a little. Help me make sure I'm covering all the bases in house design accommodations. [more inside]
posted by galadriel
on Feb 13, 2013 -
I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality hates
the MS Access solution that is being built. [more inside]
posted by rosswald
on Jan 16, 2013 -
Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
posted by monkey closet
on Dec 14, 2012 -
Our small office uses a MS Access database daily for non profit work. The database is small enough where I'm not certain it warrants upgrading to SQL. Most of the work done in the database is remote (7 users total) so we are looking to move from a standalone PC w/remote access to the cloud.
I would greatly appreciate any advice with regard to moving the DB to a cloud service provider that supports MS Access. One that is reliable, is relatively easy to admin e.g., backups and lastly, inexpensive.
posted by Sagres
on Dec 3, 2012 -
Access - trying to get by with the easiest way. There's a form and a table. After the form is filled out it needs to be printed and go to the table. Going to the table is fine. The problem - if the exact sequence of clicks is not followed then you print all the forms. Macro? Other ideas?
posted by notned
on Nov 26, 2012 -
I've switched my Access 2010 database from using Switchboard to using a Navigation Form. It's prettier and faster and it makes it impossible to print reports properly. [more inside]
posted by jeather
on Nov 7, 2012 -
I need to organise some kind of database for my non-profit training organisation, to track students, courses taken, etc in Moodle, and possibly to integrate with a Joomla site as well. I've been told that Access will not work for us. Will a Customer Relations Management thing suit us, or is something more required? If so, what should we be looking for? Requirements and constraints inside. [more inside]
posted by harriet vane
on Sep 18, 2012 -
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg
on Sep 4, 2012 -
In Access 2010 I've come across a need to concatenate fields from one column in one table into a single, comma delmited value in another field in the same table (or in another table if I absolutely must). [more inside]
posted by horseblind
on Jul 25, 2012 -
Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials. [more inside]
posted by rosswald
on Jul 20, 2012 -
Are there really no web front end design environments that are as stupid simple as MS Access form design for a SQL Server back end? I can write a real clever stored procedure for SQL Server and assign cute and short aliases to every element of the result set and crank out an Access form or forms in no time and distribute it as a light weight front end with only execute permission required. Is there some analog for a web front end? [more inside]
posted by Rafaelloello
on Apr 24, 2012 -
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 -
How do I obtain newer Foreign Service Institute language learning coursework and education materials? [more inside]
posted by andendau
on Mar 31, 2012 -
Microsoft Access programming problem - what do I have to configure in my database to make use of the DAO object? [more inside]
posted by tdismukes
on Mar 26, 2012 -
Microsoft Access: Help me streamline (or completely automate) creating weekly reports that include tables and charts. I'm almost there, but I just can't wrangle the formatting. Is it me or is it Access? [more inside]
posted by GPF
on Mar 17, 2012 -
A Microsoft Access issue: When I try to add a new variable to a pivot chart, the chart goes to a weird zoomed-in view. In this view, I can't add any new variables, nor see any trends. If I change to a different view, then back to pivot chart, everything appears as it should. [more inside]
posted by BevosAngryGhost
on Mar 8, 2012 -
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 -
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 -
I'm a low- to medium-grade computer techie. I've recently fallen in love with the remote desktop concept (I've been using TeamViewer
). I have my main PC with all my data and the software I use, setup how I like it, and then remote into that from mobile devices, friend's computers, work computers, etc., even my laptop I now prefer to use as a portal into my main PC. [more inside]
posted by Xhris
on Feb 13, 2012 -
MS Access / relational database question.
I'm trying to set up a database for a gradebook for multiple classes, that I can maintain indefinitely. I've got the basics in terms of tables for students, classes, etc. But in my ideal world, I'll be able to do item analysis, too -- like seeing what proportion of students got Question 17 correct on a certain exam, or pulling up the specific items that a student missed on Exam 3. The only way I can think of to get this level of detail is with a junction table that has a separate record matching up each test item with each student for each exam. Of course this will eventually swell into hundreds of thousands of records (students * test items * exams * classes * years). Am I thinking about this correctly? Is there a better way of designing this? Are there any examples you can point me to of databases that accomplish similar things? Thanks!
posted by svenx
on Feb 10, 2012 -
How do I connect, dsn-free, to a passworded Access (.mdb) database with php (5.2.4)? Google throws up lots of methods - none seem to work.
posted by monkey closet
on Jan 9, 2012 -
MS Access 2010 Help - I need to create something that allows a small group of people to add records and search records within a database and after much googling I'm thoroughly confused. [more inside]
posted by heavenstobetsy
on Dec 30, 2011 -
Can I get 3G access on a new Macbook Pro? If not, what is the least expensive alternative for my situation? [more inside]
posted by kmel
on Nov 18, 2011 -