Format property will not alter data and expression referencing the textbox will use actual value.
Format property will not alter data and expression referencing the textbox will use actual value.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Example expression for a textbox in Detail section: =Nz(field1,0)+Nz(field2,0)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You could create a totals cross tab and join that to your original one or use a sub form to display the results.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Thank you again June7 and everyone else that contributed. I have the results that I was looking for.