hi

Could you please expand, where do i put the exec statement

Regards

Roos

Hi

What can I say,

I was just running some test examples and working out how to use at the front end.

Many thanks to all for your prompt help, it is...

Hi Matt

Thanks

Unfortunately i cant use the duration as sometimes i dont know initially the start and finsih times, in which case if i dont the finsih time, i default the...

Hi Gail, Matt

by jove, i have managed it.

Thank you very much for your inputs, i took onboard you help and have persevered, to the point where the time and...

i have a table of records in sql which acts as the BE, in which i store the take off and landing times of an aircraft.

in this table i...

Hi

Sorry, i maybetopping out at this level.

i copied the values across to another column in the respective sql table, went to the access FE, and updated the table link to...

Hi

Many Thanks for your time in assisting me.

I dont see how i can have the date as a datetime datetype in sql, as that is part of the initial...

Many Thanks for your reply.

i have decided to hold the time and date in sql as a number with decimal, and do all the manipulations and editing in access front...