Search results

I'm looking to make a macro that will send a email to people as a alert if a criteria goes below a certain number. Anyone have any suggestions on how to go about this?

My version is not far from yours... The problem is with running "Between" on the time field "([trdate]-Int([trdate])"... It extracts the time fine, but when I run any type of filter command on it I get the ODBC error... Any suggestions? I have tried using " 6:30:00 AM" to " 3:30:00 PM", and the...

That's similar to what I'm trying to do. But I want to keep the time part static in the query and just have the date in the form. I tried ([trdate]-Int([trdate])>=TimeSerial(6,0,0) And [trdate]-Int([trdate])<=TimeSerial(15,15,0)) and it works on yours, but when I do that to my database (making...

I'm getting a error with this string, its saying "ODBC--call failed." ([datetime]-Int([datetime])>=TimeSerial(6,0,0) And [datetime]-Int([datetime])<=TimeSerial(15,15,0)) I changed "datetime" to the field name too... Note: this one works ([datetime]>=[Forms]![Form1]![StartDate] And...

Let me try to explain this better, what I'm trying to do is get that second filter to be a static range for 3:30pm to 11:59pm within that weekly qry. I want to scan for something for the week but only in a certain time range. The problem I'm running into (and i'm sure its a easy fix) is, the...

Need help with a date query Okay, Heres what I'm trying to do. I'm trying to do weekly scans on Access connecting to my database. But I want it to be time specific, I want to scan from 3:00:00 PM to 11:59:00 AM. I'm using a form to select the range and putting the time in the qry. Here's an...