Show SUM expression in text box

[MikeO]

I am trying to combine a statement leading up to the sum of a field.
Currently I use
="Total cost of items for order date "&[transactiondate] and then a separate
text box for =sum[line total]. How can I combine the 2 expressions into one
expression?
Thanks,
Mike

 

[Duane Hookom]

Try:
="Total cost of items for order date " & [transactiondate] & ": " &
Sum([line total])

 

[MikeO]

Thanks, I'll give it a try.
Mike

Try:
="Total cost of items for order date " & [transactiondate] & ": " &
Sum([line total])
--
Duane Hookom
Microsoft Access MVP

I am trying to combine a statement leading up to the sum of a field.
Currently I use
="Total cost of items for order date "&[transactiondate] and then a separate
text box for =sum[line total]. How can I combine the 2 expressions into one
expression?
Thanks,
Mike