create new column

[soniasweety]

Hi all,

I have a  time table  and opentime in   main table

I want to create a new column based on that   like

opentime+time as  DeadlineTime

how to create this ?

Main table  column[open time]  created like below

Time#(Right("OpenTime",8),'hh:mm:ss') as "Open Time"

Time table:

Load * Inline [

PId,Time[In minitue]

1,15

2,30

3,600

4,120

];

how can I achieve this?

Thanks

Sony

[Or]

I checked that syntax and it works. If it doesn't, check your data and column names.