Forum Discussion
filter 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 on a specific field & value? Thanks!
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.
4 Replies
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.
Thank you!!!!!!!!!!!
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!
- Can you summerize those questions and post them here? I'm sure you'll have better luck with the collective intelligence here on the forum.
