Many of the reports I produce need to be in two formats, the 1st shows all results in metric (cm, kg, km etc)and the 2nd in imperial (inches, gallons etc)
The reports are identical apart from the results shown and the "units" (eg inches or cm). I have tried having 2 individual reports but the reports are quite complex and if I amend 1 I have to identically amend the other which is not always easy.
I have also tried a single report but with a trigger in a select table and then the text boxes and the queries have an if statement eg If trigger = metric then show cm, else inches. But there are quite a few calculations in the report and this makes it slow to load.
Is there a better and more efficient way to do this? I am quite new to Access so don't know all of the different facilities available so pointers would be appreciated.
Thanks in advance.
The reports are identical apart from the results shown and the "units" (eg inches or cm). I have tried having 2 individual reports but the reports are quite complex and if I amend 1 I have to identically amend the other which is not always easy.
I have also tried a single report but with a trigger in a select table and then the text boxes and the queries have an if statement eg If trigger = metric then show cm, else inches. But there are quite a few calculations in the report and this makes it slow to load.
Is there a better and more efficient way to do this? I am quite new to Access so don't know all of the different facilities available so pointers would be appreciated.
Thanks in advance.