Show SUM expression in text box

  • Thread starter Thread starter MikeO
  • Start date Start date
M

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
 
Try:
="Total cost of items for order date " & [transactiondate] & ": " &
Sum([line total])
 
Thanks, I'll give it a try.
Mike

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


MikeO said:
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
Click to expand...
Click to expand...
 
Back
Top