format part of a concatenated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to take a date field and a text field and combine them to make a
third field , which would be an Invoice number. The problem I have is the
date field comes over with the slashes. I need them in the original display
of the date and not in the invoice number.

Thanks for your help.
 
Thanks for your reply. Intiially it did not work. Where am I putting this
statement? Will it go into the format property of the concatenated field?

JC

Rick B said:
Use format. Something like...


=Format([SomeDateField],"mmddyy") & [InvoiceNumber]



--
Rick B



Joe C said:
I am trying to take a date field and a text field and combine them to make
a
third field , which would be an Invoice number. The problem I have is the
date field comes over with the slashes. I need them in the original
display
of the date and not in the invoice number.

Thanks for your help.
Click to expand...
Click to expand...
 
No, it will go into an unbound text box on your report.


--
Rick B



Joe C said:
Thanks for your reply. Intiially it did not work. Where am I putting this
statement? Will it go into the format property of the concatenated field?

JC

Rick B said:
Use format. Something like...


=Format([SomeDateField],"mmddyy") & [InvoiceNumber]



--
Rick B



Joe C said:
I am trying to take a date field and a text field and combine them to
make
a
third field , which would be an Invoice number. The problem I have is
the
date field comes over with the slashes. I need them in the original
display
of the date and not in the invoice number.

Thanks for your help.
Click to expand...
Click to expand...
Click to expand...
 
It will replace your current concatenated "field".


--
Rick B



Joe C said:
Thanks for your reply. Intiially it did not work. Where am I putting this
statement? Will it go into the format property of the concatenated field?

JC

Rick B said:
Use format. Something like...


=Format([SomeDateField],"mmddyy") & [InvoiceNumber]



--
Rick B



Joe C said:
I am trying to take a date field and a text field and combine them to
make
a
third field , which would be an Invoice number. The problem I have is
the
date field comes over with the slashes. I need them in the original
display
of the date and not in the invoice number.

Thanks for your help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top