format part of a concatenated field

[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.

 

[Rick B]

Use format. Something like...


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

 

[Guest]

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

Use format. Something like...


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



--
Rick B

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.

 

[Rick B]

No, it will go into an unbound text box on your report.


--
Rick B

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

Use format. Something like...


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



--
Rick B

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.

 

[Rick B]

It will replace your current concatenated "field".


--
Rick B

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

Use format. Something like...


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



--
Rick B

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.

 

[Guest]

Rick,

Thanks. You're back in the will.

Appreciated.

Joe C.