Concatenate on a form

[Jim L.]

On a form, a user will enter data into a date control and a time control. I
have hidden controls next to them that reformat the date to read yymmdd, and
the time to read hhmm without the slashes, colons or spaces. How can I
combine these two controls to become a unique report number?

 

[Arvin Meyer [MVP]]

Format([DateField], "yymmdd") & "-" & Format([TimeField], "hhmm")

or the out the "-" altogether. BTW, You can put both in a single textbox and
still format them like the above, using slightly different syntax.

 

[Jim L.]

Thanks Mr. Meyer. I was close, but this worked perfectly.

Format([DateField], "yymmdd") & "-" & Format([TimeField], "hhmm")

or the out the "-" altogether. BTW, You can put both in a single textbox and
still format them like the above, using slightly different syntax.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

On a form, a user will enter data into a date control and a time control.
I
have hidden controls next to them that reformat the date to read yymmdd,
and
the time to read hhmm without the slashes, colons or spaces. How can I
combine these two controls to become a unique report number?

 

[Douglas J. Steele]

For that matter, you could also use

Format([DateField] + [TimeField], "yymmdd-hhnn")

or

Format([DateField] + [TimeField], "yymmdd hhnn")


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Format([DateField], "yymmdd") & "-" & Format([TimeField], "hhmm")

or the out the "-" altogether. BTW, You can put both in a single textbox
and still format them like the above, using slightly different syntax.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

On a form, a user will enter data into a date control and a time control.
I
have hidden controls next to them that reformat the date to read yymmdd,
and
the time to read hhmm without the slashes, colons or spaces. How can I
combine these two controls to become a unique report number?