i have a database that i want to limit the average user from editing records that

aren't his

aren't time

(aren't billed OR

aren't being prepared to be billed)

so they have to be his time and not billed or being billed. for some reason i can't get the last part to work. i can get it to not let the user edit anything that isn't his time and billed but the OR BEING BILLED is the problem. i think the problem is syntactical. here is what i wrote:

Created by = Status(CurrentUserName) and Expense = "Time"

and

(Billed = "No" or Billed 2 ? "Yes")

and i tried variations of this to no avail.

any help would be much appreciated.

thanks in advance.

Limore

I'm assuming the question mark is 'not equal to'. I'm also assuming Billed 2 is a flag of "yes" for being prepared. If this is correct, it appears that it should work. What are your other options for Billed 2, is it just "no"? If so, why not use Billed 2 = "no"?

Also, I don't think it should be an issue, but you might want to verify that the test isn't case-sensitive, so that if "no" is selected, the test for "No" doesn't result in false.

yes it is a not equal to and it is cap No and cap Yes. and i tried it with equal to No and not equal to Yes and neither work. and i am using the exact case in the value list as i am in the calculation. any other ideas??? puzzling, truly.