Thanks for the response, i used a subquery to complete the task.

I did the first set of computations in the subquery, then reused those fields within the query...i'm still new...

Thanks, I've inlcuded formulas directly in the queries

hmm...I'm not sure how DTS fits in the picture; hope I'm not in the wrong forum..

The data is stored in an Access database and not in SQL Server

I had partial success with the following code (i converted the macro to a module and called that module using runcommand:

Private Sub Form_Load()

If Time() >= #2:09:00 PM# And Time() <=...

Thanks guys for all your responses....I'll make a go at it during the day and let you know my progress..

Thanks