Can I have Sum NOT in the footer?

[beenut23]

Hello good people. Could someone kindly tell me if I can have a textbox with a sum of other textboxes in it, and NOT have my sum in the footer of the report? I have a textbox with the following control source, and it always is empty?

=Nz([txtTime1]+[txtTime2])

Both txtTime1 and txtTime2 have numbers in them, but this textbox is blank.

many thanks to you all for your assistance.

 

[JBinQLD]

How odd. That works perfectly here although of course if txtTime1 and txtTime2 contain text Access will concatenate them. Use:

=Nz(val([txtTime1])+val([txtTime2]))
[\code]

This ensures that access treats them as numbers.  This is probably a silly question but you have ensured the text box is visible, isn't out of range etc?  Try just forcing ="1" into it an making sure you can see that?

JB

 

[dhookom]

Are all of your text boxes in the same report section?

Duane
Hook'D on Access
MS Access MVP

 

[GShen]

Do txttime1 and txttime2 have numeric values in EVERY single record being returned from your query?

Remember when... everything worked and there was a reason for it?