var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Filter on Control Source of curreny filed of detail record in a report?
Contorl source for currency field SP
[SP] >=100000 AND <=299999
The report is NOT based on a query but the table itself. I trie filtering the [SP] field in the table. Failed.
Do you mean you have set the ControlSource for a field on your report to
[SP] >= 100000 AND <=299999
That does not work in a ControlSource for any field, currency or not.
Are you trying to filter the data for the report? If so, you will neet to do that with a query, or in the filter parameter in the .OpenReport command.
Your syntax appears wrong anyhow. Try this
[SP] >=100000 AND [SP] <=299999