Hi,
Please can you help me to change the following on my report to show the total as currency. It is in the control source and I am trying to make it show as part of a sentence.
Also, if possible the following as ddd d mmm yyyy, h:mm am/pm
Many thanks,
Malcolm
Please can you help me to change the following on my report to show the total as currency. It is in the control source and I am trying to make it show as part of a sentence.
Code:
=[NewName] & " (£" & Sum(([Total])) & ")"
Also, if possible the following as ddd d mmm yyyy, h:mm am/pm
Code:
=Date() & ", " & Time()
Many thanks,
Malcolm