Hello My friends,
If you check to Picture i have 3 Records.
i have 2 questions here :
1- How can i show on screen Bus > Budget Total with text box ?
2- Please IGNORE Total and how can i sum For example Truck Budget AA + Budget BB
shall i write for every 3 records different Query or is there a simple Code like that :
But this is suming field not first row or second one...
Hope so you can help me... Thanks.
If you check to Picture i have 3 Records.
i have 2 questions here :
1- How can i show on screen Bus > Budget Total with text box ?
2- Please IGNORE Total and how can i sum For example Truck Budget AA + Budget BB
shall i write for every 3 records different Query or is there a simple Code like that :
Code:
=DSum("[Budget AA]";"[Q_Budget]")
But this is suming field not first row or second one...
Hope so you can help me... Thanks.