Join Fields

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

Guest

I have 2 fields on a form that I want to work with. They are RTARef (a
numeric field) and CreationDate.

I want the output as CG/RTA/0000000/yy where yy is the year from the
creation date and 0000000 is the RTAref.

How do i join these together.
Thanks in advance
 
Try

"CG/RTA/" & [RTAref] & Format([CreationDate],"/yy")

For what purpose do you need that?

If it's a fixed strig don't store it in a table, you can always get this
combination using a query.
 
Back
Top