Display sub form total

[foxtet]

Hi Guys,
I want the the text box (txtTot) to display sum of the amount colum of qryConsigneeExpDetails subform,

I used the following expression as defult value of txtTot but it displays sum of query amount total. =DSum("[Amount]","qryConsigneeExpDetails")

What can be the solution to display only the sub form total on the txtTot

foxtet

 

[bob fitz]

Is this what you are trying to do:

 

[foxtet]

Is this what you are trying to do:

Exactly you solved the problem.

Thank you

foxtet

 

[bob fitz]

Exactly you solved the problem.

Thank you

foxtet

Glad to be of some help

Feel free to ask if you have any questions on the solution.

 

[foxtet]

Is this what you are trying to do:

Thank you.
Is that possible format the vale displayed in txtTot in the format shown below
eg:
1,200.00 instead of 1200

foxtet

 

[bob fitz]

You could try changing the Format property to Standard and the Decimal Places property to 2

 

[foxtet]

You could try changing the Format property to Standard and the Decimal Places property to 2

Thank you!

 

[bob fitz]

Thank you!

You're welcome. Good luck with your project.