Search results

Unfortunately there is no CDATE or ROUND in Access 2.0. Maybe I'm hooped?

Access 2.0 says "Undefined function "Round" in expression". I think I see where you're going with this. As you can see, second accuracy however is all that's needed and that why you're rounding. Can you just cut off (ignore) the 10ths of seconds instead of rounding up? BY the way, how did...

Here it is. It's the BAVARD query that I'm working on. It won't import into my Access 2007 so I working on it inside a W2k VM running Access 2.0 Maybe you can open it? Here is a heads up on how the report is being generated: Report FORM - DATE DEFAUT ANCIEN opens (on open) Function...

You can see from my original post the original criteria that worked, but not the way I wanted it to. Here's the criteria I was playing with that have hard dates and time that don't work either. I get a blank query. date criteria: >=#7/12/2010# And <=#7/13/2010# time criteria: >=#6:00:00 AM#...

G81: Was thinking myself that a sub-query might be the best answer although joining the fields was something I wondered about too. I'm not a db guru; I'm an industrial PLC programmer so this is not my forte. lagbolt: valid comments about the architecture but it's what I have to work with as I...

My first post! Glad to have found such an exceptional forum. I am trying to figure out how to get a query that was designed to show data from 1 or more days from time 1 to time 2 to show data from date 1, time 1 to date 2, time 2 and I'm stumped. I got as far as getting day 1, time 1 to day...