S
Stuart
Hi all,
I have a problem that I just cannot figure out for the
life of me.
I am trying to set up a database that contains time slots
(6 X 4hr periods to cover the day) starting from 00:00:00 -
03:59:59 etc etc etc.
DB Fields look like this
| ID | EmailAdress | FromTime | ToTime |
Now once some one does an event of some sort, I wish to
email the person(s) contained with in the database.
The SQL string I am using in Select EmailAddress from
tblTable where #time()# BETWEEN FromTime and ToTime.
This however is causing me to get either 2 records (one is
correct one is wrong) displayed or no records displayed.
Am I doing this completely wrong? If so is there another
way?
Many thanks for help on this
Stuart
I have a problem that I just cannot figure out for the
life of me.
I am trying to set up a database that contains time slots
(6 X 4hr periods to cover the day) starting from 00:00:00 -
03:59:59 etc etc etc.
DB Fields look like this
| ID | EmailAdress | FromTime | ToTime |
Now once some one does an event of some sort, I wish to
email the person(s) contained with in the database.
The SQL string I am using in Select EmailAddress from
tblTable where #time()# BETWEEN FromTime and ToTime.
This however is causing me to get either 2 records (one is
correct one is wrong) displayed or no records displayed.
Am I doing this completely wrong? If so is there another
way?
Many thanks for help on this
Stuart