UtterAccess.com
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
> Dynamic Forms With Query Reference., Access 2010    
 
   
KPN
post Apr 10 2017, 08:06 AM
Post#1



Posts: 40
Joined: 20-May 10



Hi Guys. Can the CCF sum in the subform change with the company selected in the main form? Thanks alot.
Attached File(s)
Attached File  Database2.zip ( 476.93K )Number of downloads: 4
Attached File  Database2.zip ( 476.93K )Number of downloads: 1
 
Go to the top of the page
 
ranman256
post Apr 10 2017, 10:06 AM
Post#2



Posts: 719
Joined: 25-April 14



if the subform is linked to the parent form,
then changing records in the parent will change the subform records and the total.

put a TEXT box in the subform footer, =SUM(field)
Go to the top of the page
 
KPN
post Apr 11 2017, 07:16 AM
Post#3



Posts: 40
Joined: 20-May 10



Thanks ranman256. The attachment shows a "total withdrawal" field that works as explained. the "CCF" field on the other hand does not change. The CCF field is from a query field not directly from a table field in the form.
Attached File(s)
Attached File  Database2.zip ( 475.99K )Number of downloads: 2
 
Go to the top of the page
 
mike60smart
post Apr 12 2017, 01:33 PM
Post#4


UtterAccess VIP
Posts: 12,054
Joined: 6-June 05
From: Dunbar,Scotland


Hi

What does CCF stand for??

What value would you want to see for the First Record displayed??


--------------------
Hope this helps?

Mike

Get happiness out of your work or you may never know what happiness is.

Go to the top of the page
 
KPN
post Apr 21 2017, 06:05 AM
Post#5



Posts: 40
Joined: 20-May 10



Hi Mike, Sorry for late reply.

CCF (ProfiitLoss) is a summation of the [amount] field from the "View Transactions With Account" query for all the records in the company under review.

All figures in the [amount] field are entered as positive even though the expense entries should be negative while revenues are positive.

Because I did not want to have to enter a negative sign for expenses for each record, I used the "View Transactions With Account" query, to make expenses negative and keep revenues positive.

The CCF box references the "View Transactions With Account" query and sums up the [Amount].

Trouble is, the expression I used in CCF, sums all transactions from all companies.

I'd like to sum the [Amount] field from the query "View Transactions With Account" and have it change as the company on the form changes.

It would be nice to explore other ways. Ways that do not necessarily require a query. Ways that I may not be too familiar with. Such as a filter macro.

Thanks Mike.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    29th June 2017 - 10:58 AM