Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best way forward with duplicate reports

Status
Not open for further replies.

NeilT123

Technical User
Jan 6, 2005
302
GB
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.
 
eh, are all the calculations on the report or the query?

if they are all on the query, then you can just bound the report to the relevant query and then, you can probably include a set of "units" in the 2 queries, and use textboxes on the report to display the units.


--------------------
Procrastinate Now!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top