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 -
1 answer
Seeking recommendations for on-line training on business applications, particularly MS Office.
[more inside]
posted by dg
on Sep 4, 2012 -
8 answers
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
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'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such:
[more inside]
posted by thankyoumuchly
on Sep 8, 2011 -
3 answers
Which programming languages are best suited to creating a timetabling application?
[more inside]
posted by bister
on Jun 26, 2011 -
16 answers
I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside.
[more inside]
posted by filthy light thief
on May 16, 2011 -
7 answers
Microsoft Access 2007 - how on earth do I cut / copy / export / do
anything with my Pivot Chart, besides print it?
[more inside]
posted by Jimbob
on Nov 23, 2010 -
12 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
Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using
bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach?
[more inside]
posted by Monday, stony Monday
on Nov 19, 2009 -
7 answers
Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside.
[more inside]
posted by TheBones
on Aug 11, 2009 -
17 answers
How to extract data automatically from a group of HTML pages to an Excel file or to a database?
[more inside]
posted by elgilito
on Apr 22, 2009 -
5 answers
I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template.
[more inside]
posted by Inkoate
on Oct 11, 2008 -
1 answer
I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients.
[more inside]
posted by dance
on Nov 5, 2007 -
2 answers
I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable.
[more inside]
posted by chrispy108
on Oct 8, 2007 -
6 answers
How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like
this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row.
[more inside]
posted by bokinney
on Mar 12, 2007 -
7 answers
I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet.
[more inside]
posted by elle.jeezy
on Jan 3, 2007 -
3 answers
Some colleagues are trying to export a MS Access report to Excel. Here's the error they get:
[more inside]
posted by ao4047
on Nov 6, 2006 -
4 answers
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I?
[more inside]
posted by Marnie
on Aug 22, 2006 -
4 answers
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank.
[more inside]
posted by godawful
on Feb 10, 2006 -
9 answers
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table?
[more inside]
posted by clgregor
on Sep 2, 2005 -
5 answers
I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead
on Aug 19, 2004 -
10 answers
