combine two expressions

G

gls858

I have two expression that give an start date date and a end date:

=[Forms]![frmUsageReport]![txtStartDt]
=[Forms]![frmUsageReport]![txtEndDt]

I currently have them in two text boxes with a label box for the "to"
is it possible to combine all three into one text box? I can't seem to
get the right syntax.

gls858
 
W

Wayne Morgan

Try

=[Forms]![frmUsageReport]![txtStartDt] & " to " &
[Forms]![frmUsageReport]![txtEndDt]
 
Top