filter data on import

[sshweky]

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!

[pqian · Accepted solution]

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.

[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!

[pqian]

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.

[sshweky]

Thank you!!!!!!!!!!!