Formula Help

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

Lee-Anne Waters via AccessMonster.com

Hi,

hopeing for some help please...

i have a form which has a start time (10:00) and a end time (12:00) there is
then another field where the user keys in the actual start time (11:00).

what i need to be able to do is if the the user enters a start time less than
the start time or greater than the end time then a msg box alerts them to
this.

i cant seem to get the formula to work with times??

any ideas
thanks
Lee-Anne
 
Hi,

hopeing for some help please...

i have a form which has a start time (10:00) and a end time (12:00)
there is then another field where the user keys in the actual start
time (11:00).

what i need to be able to do is if the the user enters a start time
less than the start time or greater than the end time then a msg box
alerts them to this.

i cant seem to get the formula to work with times??

any ideas
thanks
Lee-Anne
Click to expand...

Hi Lee-Anne,

Here's a resource you should bookmark. It is probably the best
Access resource on the web!

http://www.mvps.org/access/toc.htm

Look under Date/Time.

HTH
 
Back
Top