Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Count of time


Recommended Posts

Hi There,


I have a little problem. In my maindatabase there is a field (Time) with a time in it and a summary field called Count Time (=Total of Time (running).


The second database is connected by a one to one relationship.

The layout of the second database shows serveral records from the first database (Header, Body, Trailing and Grand Summary).

In the Trailing Grand Summary i placed the field Count Time from the main database but it won't count all of them, just one.


Any suggestions?


Tnx Oh Really!

Link to comment
Share on other sites

Summary field will only work if the layout is based on database (table) one, because they work by summing the contents of Time field in each record in the body. If the layout is based on database (table) two, and you are showing each records related Time field (from table one) unfortunately putting the summary field in trailing grand summary aint gonna cut it.




Quick fix is create a field on second database called "Time" which is a calculation, and is set to the related Time field in database one (from the matching record). Create a summary field on table two, which is the total of the new Time field. Place the new Time field in the body part, and the new summary field in the trailing grand summary




Now everything on the layout is essentially from the table the layout is based on, so the summary field should work as expected.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use