Format Query

A

ANDY

I have this in a query, which works fine

barcode: "RTA/CG/" & [ID] & "/" & [DATE]

My question is - how do i format the date to just display
the last two numbers of the year.

Thanks

Andy
 
R

Rick Brandt

ANDY said:
I have this in a query, which works fine

barcode: "RTA/CG/" & [ID] & "/" & [DATE]

My question is - how do i format the date to just display
the last two numbers of the year.
Click to expand...

barcode: "RTA/CG/" & [ID] & "/" & Format([DATE], "YY")
 
G

Guest

thanks
-----Original Message-----
ANDY said:
I have this in a query, which works fine

barcode: "RTA/CG/" & [ID] & "/" & [DATE]

My question is - how do i format the date to just display
the last two numbers of the year.
Click to expand...

barcode: "RTA/CG/" & [ID] & "/" & Format([DATE], "YY")

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Top