Ignore Certain Values

[Eranka]

Hi

i am trying to show the data values between 0 and 4 hours, but within these limits i want to ignore data if the Session_ID = Evening and Acceted_Hours = 3:00. how to do this part?

Like (>#12:00:00 AM# And <=#3:59:00 AM#) And Not ([Session_ID]="Evening" And [Accepted_Hours]=#3:00:00 AM#)

i tried above but not working. **this is to include in a access query**

[June7]

LIKE is only useful with wildcard character.

Try:

[Accepted_Hours]>#12:00:00 AM# And [Accepted_Hours]<=#3:59:00 AM# And Not ([Session_ID]="Evening" And [Accepted_Hours]=#3:00:00 AM#)