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.
- sshweky
Thank you!!!!!!!!!!!
- sshweky
By 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.
