M
Markie
Guest
Hi
I have a table and I would like it to auto generate a Program code made up from other fields.
I.e.
ProgramType ta
Period 04
Year 2002
ProgramCode would then equal [ProgramType]&"-"&[Period]&"-"&[Year]
Program Code ta-04-2002 or ta-04-02
Can this be done in a table at all?
Concatanation is not the issue, I understnand that and use it elsewhere. I cant get the table field to calculate using the entries in other fields in the same table.
I am trying to code it but falling short.
I have been all over the net to no avail and my manuals fall short.
If you have the time any suggestions would be greatly appreciated.
Cheers
I have a table and I would like it to auto generate a Program code made up from other fields.
I.e.
ProgramType ta
Period 04
Year 2002
ProgramCode would then equal [ProgramType]&"-"&[Period]&"-"&[Year]
Program Code ta-04-2002 or ta-04-02
Can this be done in a table at all?
Concatanation is not the issue, I understnand that and use it elsewhere. I cant get the table field to calculate using the entries in other fields in the same table.
I am trying to code it but falling short.
I have been all over the net to no avail and my manuals fall short.
If you have the time any suggestions would be greatly appreciated.
Cheers