X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Total Based On Contents Of A Subview Table, Access 2013 Web App    
post Mar 20 2017, 08:58 AM

Posts: 59
Joined: 22-October 15

Hi Folks!

I have a subview with the lines from a contract, each of which has a line total for the value of the line. I was using a RIC to display the appropriate contracts lines on the Contracts List view, but was getting a weird error in which line items which start with a '0' weren't being displayed. So, I moved to a subview, which is working great, only now I can't find a way to display the total contract value by calculating the sum of each of the displayed lines. Can I do this using a datasheet subview or do I have to use a summary sub? frown.gif

I thought I'd seen Jeff conrad use some code in a txtbox like =calculation.sum or some such but can't find it anywhere.

Go to the top of the page
post Mar 21 2017, 12:05 PM

Posts: 372
Joined: 25-November 14
From: Groningen, Netherlands

If you make a sum query with one or more parameters that gives you what you want, I'd call that with a datamacro on the OnCurrent Trigger and place it in an unbound textbox control on the main form.
Kind regards,
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    27th March 2017 - 11:17 AM