I have two fields in MS Access 97. One has 7:45:00 and the other has 7:43:03. I want to subtract the difference and get 117 seconds. How can I do this?

Thanks

Look up the DateDiff() function, with the seconds switch. Should do what you're asking, provided the fields are actually Date/Time type.

HTH,
David R