Multiple validation rule for a single cell

  • Thread starter abu_saleh via AccessMonster.com
  • Start date
A

abu_saleh via AccessMonster.com

Hello:

I have a question?

Example: If I have a validation rule for

"Time In" on cell A01

Allow: Custom
Formula: =AND(B10<A10, B10>"12:00:00 AM"+0, B10<"11:59:00 PM"+0)

AND

"Time Out" on cell B01

Allow: Custom
Formula: =AND(A10>B10, A10>"12:00:00 AM"+0, A10<"11:59:00 PM"+0)

How can I add validation for
if the Time In cell has enter a value than Time out can not be empty or null.
Vise versa,
if the Time Out cell has enter a value than Time In can not be empty or null

Any help will be appreciated.

Thanks.

Abu Saleh
 
P

Pete D.

You would do better in an Excel newsgroup, This group is for MS Access the
data base program. Try
microsoft.public.excel
 
J

Jeff Boyce

"Cells" happen in spreadsheets.

This newsgroup supports questions about Microsoft Access, a relational
database.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

abu_saleh via AccessMonster.com

Thank you for your reply, I will try that.

abu_saleh said:
Hello:

I have a question?

Example: If I have a validation rule for

"Time In" on cell A01

Allow: Custom
Formula: =AND(B10<A10, B10>"12:00:00 AM"+0, B10<"11:59:00 PM"+0)

AND

"Time Out" on cell B01

Allow: Custom
Formula: =AND(A10>B10, A10>"12:00:00 AM"+0, A10<"11:59:00 PM"+0)

How can I add validation for
if the Time In cell has enter a value than Time out can not be empty or null.
Vise versa,
if the Time Out cell has enter a value than Time In can not be empty or null

Any help will be appreciated.

Thanks.

Abu Saleh
Click to expand...
 
Top