Negative times

[KCA]

I have created a field in my query that calculates a time difference, although as expected it doesn't work when start time is before midnight and end time after midnight.
I had a search through the forum and came up with following thread :

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=13201

Now, where do I put this code ?? I tried both suggestions on several places, but I get errors all over...

Thanks, Koen

 

[Rob.Mills]

You'd put that code where you normally would put the name of a field in the recordsource that you're querying.

 

[Rob.Mills]

Without the equal sign

 

[KCA]

Rob, I can't get it to work, it's giving me a syntax error when exiting the name field in the query design. It says missing operator or wrong character, etc. in both suggestions that were made in the thread I referred to. Any ideas what is wrong ?

 

[Rob.Mills]

Can you attach a picture of your query in design view. Make sure that the columns are expanded enough to see everything.

 

[KCA]

OK !!!!

I was calling for help too early again !!!

I fixed it by setting the calculated field properties, format to standard date and then the formula [end time]-1-[begin time]. Works perfect !!

Didn't see yet you already replied on my 'panic reaction', thanks a million for the help you've given me so far, Rob.

Koen