I need to limit the content of the two fields: one is open data, between 2014/06/01 and 2014/07/01; the other is country, include China, Hong Kong, Taiwan, Japan and Korea.
I want to know how to limit? thank you!
You want script side... if yes you can use like
Where Date >= Date(2014/06/01,'YYYY/MM/DD') and Date >= Date(2014/07/01,'YYYY/MM/DD') and
Match(Country, 'China', 'Hong Kong', 'Taiwan', 'Japan','Korea');
Hi Bing Bin,
If you want to limit the data at the opening of the file and need to reuse field values again, use Triggers on the two fields.
go to > settings > Documents Properties> Triggers> on open > add actions
WHERE WORK_GROUP in ('Administration', 'Call Administrator', 'System Administrator', 'CNA_CCR')
The SQL SELECT statement is just that, a SQL statement, which means the error being returned to you is a SQL error.