Forum Discussion
sshweky
Helper III
Helper IIIfilter data on import
I am importing data from Access & Excel. I would like to filter the data I import from each table based on certain criteria. Is there any way I can use the advanced query editor to set a filter based...
Can you elaborate a bit on the "based on a specific field & value" part?
in the queries editor, the each column of the table has a drop down button. Clicking on it will bring down a list of distinct values, and you can choose which ones you want to filter out from there.
pqian
Microsoft Employee
Microsoft EmployeeCan you elaborate a bit on the "based on a specific field & value" part?
in the queries editor, the each column of the table has a drop down button. Clicking on it will bring down a list of distinct values, and you can choose which ones you want to filter out from there.
sshwekyHelper III
Helper IIIBy the way, are you available to consult on my project for an hour tomorrow? I have some issues that I cant get through and have some questions about capabilities. Thank you!
- pqianCan you summerize those questions and post them here? I'm sure you'll have better luck with the collective intelligence here on the forum.