filtering for many items in access 2003

[Niven]

Hello,



Please forgive me if I sound lost, I am a beginner to access and databasing.

How do I filter for more than 1 item in a database? I have a list of entries in an excel coloumn that I know is in the database. Instead of typing each entry in advanced filter, how do i search for all entries to be displayed at once?

Your help is much appreciated.

thank you

[Niven]

There is about 4000 entries in the excel file, and it would be impractical for me to type it in one by one.

[alansidman]

Are you looking to display the entire 4000 entries. I am confused by your statement. Also, what does the Excel spreadsheet have to do with your db? Where are you looking to do your filter? In a form, In a query?

[Niven]

There is about 4000 entries in the excel file, and it would be impractical for me to type it in one by one.

hi thanks for the reply, sorry for not being clear.

In access 2003, when you go to advanced filter, you can only type in one search criteria at a time. Now I have a spreadsheet which has entries in a single coloumn, whereby I know that they exist in the database. Instead of me having to type in each entry in the filter critera, is there a way I can filter for more than one entry, by just copying and pasting the entries from the spreadsheet into the filter bar?

[alansidman]

Why not use the autofilter and then select in the drop down your choices to filter on. I am a little confused by your response. Are you trying to filter in Access or Excel. If in Access, are you attempting to filter in a table? Look at this: http://www.timeatlas.com/5_minute_ti...l#.UP9ABx2EqSo

You can use this feature to filter in both a spreadsheet and an Access table. If this is not what you are trying to do, post back with further details.