Search results for query: *

Have you checked to see if [field1] and [field2] are set up as a date field and if you are using a built in function to populate either field, this might cause your problem.

Thanks everone, I found the error, I used 2 different set values one was now() and the other was date(), since I changed them both to now(), everything works fine. Larry

Both data types date/time fields, I have to check, I have the field set by an event and I think I used now() to set the time. Would this be where the error is.

Hello, I am using this function in a query to show the difference between 2 times in minutes, the results returned do not make sense. Sample DateDiff("n", Date1, Date2) Date1 = 6:00 P.M. Date2 = 6:01 P.M. Result comes back as an 8 digit number 5629041 Thanks in...

PHV, Thanks, I was able to solve my problem. Larry

Darryle Thanks

I use a sign in form for customers at a reception desk and a serviced form that gathers information as the customer is serviced. Do not know how to have the serviced form have the new customers show on their form, after they first open the form at the start of the day. Thanks in advance.

Now I know, works great, thanks

I need to only show records that have been created today whenever the form is opened. The problem I have is that when the form is closed and re opened, the filter does not work, I have to reset the filter.