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

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted 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 on Oct 8, 2007 - 6 answers

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted on Jul 2, 2007 - 3 answers

How do you create text files from a spreadsheet? [more inside]
posted on May 2, 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 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 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 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 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 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 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 on Aug 19, 2004 - 10 answers