Ok!!
I am trying to calcualte the number of hours and minutes between two fields which then are stored in the database - (not a running total)
and then multiply the number of hours and minutes by a Rate (i.e £2.50) and then also store this value down.
can any body help??
can you please also let me know exactly what data types each fieds should be, i have tried several different datatypes which has also brought different problems.
Sushil
I will say thank you now for your help!!
I am trying to calcualte the number of hours and minutes between two fields which then are stored in the database - (not a running total)
and then multiply the number of hours and minutes by a Rate (i.e £2.50) and then also store this value down.
can any body help??
can you please also let me know exactly what data types each fieds should be, i have tried several different datatypes which has also brought different problems.
Sushil
I will say thank you now for your help!!
