How do I add Filter on Linked Table?

M

mikename

I am using Access2007 and SharePoint2007. I linked a SharePoint list into
Access. It always get all records from SharePoint list when I sycn the linked
table in Access. How can I add a filter on linked table? -- Just to get a
part of records from list according to filter. Thanks.
 
T

Tom van Stiphout

On Sun, 14 Sep 2008 19:41:01 -0700, mikename

No, but you can create a query based on the linked table, and use it
to filter the data.

-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

Similar Threads

Ms Access 2007 and Ms Sharepoint 2007 (Issue with Attachments) 2
Macro for Sharepoint List and another Table?? Same # records? 1
Using "OpenRecordset" on Linked Table Issue 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked Sharepoint Table 2
Sharepoint Table Refreshlink? 1
Like Filter in 07 4
Connection timout 0 5

Top