By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,558 Members | 1,607 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,558 IT Pros & Developers. It's quick & easy.

Report - Totalling an Unbound Field?

P: n/a
Hi,

I have a report driven by a SQL database. I have a populated recordset
having a user name and a number of data/time fields. I process these
time fields in the report's Detail_Print event. Basically I'm coming
up with a duration between 3 sets of dates (subtracting off hours -
eve, lunch, weekends, holiday) and coming up with the number of
seconds. In the detail list I can easily print the value of n days,
n hours, n minuts, n seconds.

However now I want to make a simple Average Report which just lists the
User and the average time. Using Access 2002 I have not been able to
figure out how to use group totalling to even get a total of an unbound
field.

I have an unbound field called: txtSubmitReviewDateDiff which is
updated from VBA in the Detail_Print event. This works great for the
basic detail print.

I added a hidden field to the detail line called: txtSubmitRunningTotal
which is set to be a "running sum" and has it's control source set to
=[txtSubmitReviewDateDiff].

When I run the report (with the hidden sum field temporarily unhidden)
I see the same value in both columns.

Can I use the reports built in methods to sum an unbound field? Any
suggestions are greatly appreciated.
Thanks

Aug 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.