How to Import Spreadsheets and Filter data into Reports

B

BrianM22

Hi guys, I'm a bit of a newer Access 2007 user and am trying to find a
solution for my boss. He receives a monthly excel spreadsheet that includes
about 8000 patients that require their medication information to be reviewed.
Of the 8000, many will be cancer patients or have waivers. Those patients
don't require review. He'll be working to figure out which don't require
review.

Now, he can eliminate the patients that don't require review and review
those that do, but next month he'll get a list with all the same names. This
will be a recurring list of the same and more names each and every month.

I'm trying to find an easy way to minimize the workload. I was thinking to
maybe have a table such as cancer patients and one with waiver patients.
Perhaps each month I could import the spreadsheets with all the patients into
these tables, then spit out a query that would remove all the cancer and
waiver patients. That way it would be a workable list for him with very
little manual work.

This is me thinking out loud. Does this seem like a workable solution? I'm
not quite sure how to make this happen if so. Can you provide any help or
other ideas. This is driving me nuts.
 
T

Tom van Stiphout

On Mon, 22 Feb 2010 15:34:01 -0800, BrianM22

Perhaps even simpler is to import the entire table, and then create a
query that eliminates the rows you don't need to see. I don't know how
you determine this is a cancer patient or one that has a waiver, but I
assume it's in the data somehow.
Then you could create a query that says something like:
select * from myPatients
where myDataField <> "cancer" and myOtherDataField <> "waiver"

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top