Report Problem

[Marko via AccessMonster.com]

Hi all,

I have a report which is only 1 page and the report's record source,
originally, is the data table. because I wanted to capture and display the
recorded time in hours and minutes, I created a query which contain an
expression as below:

Minutes: (DSum("timeOut","[CounterLogTable Query]")-(DSum("timeIn","
[CounterLogTable Query]")))

And on the report itself, I have a text field which I set the records sources
to:

=Format(Int([Minutes]/60) & " HOURS " & [Minutes] Mod 60,"Short Time") +
"MINUTES"

This has increased my report from 1 page into 68 pages (all the same). I've
tried to changed the record source of the report back to the data table and
set the text field sources to:

=((DSum("timeOut","[CounterLogTable Query]")-(DSum("timeIn","[CounterLogTable
Query]")))/60

which give me a correct count on hour but the minutes is off (instead of 51
minutes, it display as .85, which I guess is 85% out of 60 minutes). By
changed such record sources, the report went back to 1 page. I wuold like to
keep the Query as the record sources for the report and the report text
field's record sources to
=Format(Int([Minutes]/60) & " HOURS " & [Minutes] Mod 60,"Short Time") +
"MINUTES"

Is there a way to keep the report at 1 page? It wuold be ok if I am the only
person to print the report, I cuold print page 1-1, but there is other people
also viewing and printing this same report which wuold come out 68 same pages.


Thanks

 

[Duane Hookom]

Your report seems highly unconventional and I expect there is a better
solution to get what you want. However, you haven't provided much information
about your tables, data, fields, and desired display in the report.