need duplicate column

[sachinmalik007]

i have a table iodata with the following field.

date
holder name
iotime

data input automatically daily from access control system into the table.

my requirement is : i need one extra column in same table with same data as iotime and duplicate column should have exact data as iotime.

 

[Addyman]

Could I please ask why? If the data is in there in a column, why do you need a second column showing the exact same information?

Perhaps you could explain your requirements a little more?

 

[gemma-the-husky]

same question - but if it is a matter of capturing a time in the first instance, and one of them might be modified later ....

then add the fields, and do an update query to set the values for the new fields to be the same as for the existing fields.

 

[sachinmalik007]

Actually existing column's data type is text and i want data type in date/time.
actually i want to do some calculation like max(iotime) - min(iotime) = working Hrs.

Pl. suggest me to calculate working hrs on text field.
Data come in iotime field from Access control system as 08:00:05.