H
hughess7
Hi all
One of my databases (Access 2003) is used across Europe etc and the reports
are produced in the local country language. In order for the dates and
numbers etc to be produced in the correct format per country, the office
staff change their country settings before previewing the reports. This has
always worked well, but recently I introduced a chart and we have problems
with this displaying for certain countries.To get the chart to preview we
have to select a different country and tweak the settings. For example, for
France we have to use Belgium French settings.
I have just noticed one problem, I have a calculated control in a query (see
below) which works for the UK, but when I choose France I get #Error in the
field.
AppliedCB:
IIf([IssueCodeResult]=2,0,IIf([IssueCodeResult]<3,0,IIf([IssueCodeResult]=3,[ClaimValue]*[APICalc],[ClaimValue])))
This may be a red herring as it didn't error before, it just didn't display
the report (blank page - header/footer only).
Has anyone else had experience with multi-country settings that can offer me
any advice?
Thanks in advance for any help.
Sue
One of my databases (Access 2003) is used across Europe etc and the reports
are produced in the local country language. In order for the dates and
numbers etc to be produced in the correct format per country, the office
staff change their country settings before previewing the reports. This has
always worked well, but recently I introduced a chart and we have problems
with this displaying for certain countries.To get the chart to preview we
have to select a different country and tweak the settings. For example, for
France we have to use Belgium French settings.
I have just noticed one problem, I have a calculated control in a query (see
below) which works for the UK, but when I choose France I get #Error in the
field.
AppliedCB:
IIf([IssueCodeResult]=2,0,IIf([IssueCodeResult]<3,0,IIf([IssueCodeResult]=3,[ClaimValue]*[APICalc],[ClaimValue])))
This may be a red herring as it didn't error before, it just didn't display
the report (blank page - header/footer only).
Has anyone else had experience with multi-country settings that can offer me
any advice?
Thanks in advance for any help.
Sue