Hi I am trying to use a query or table field as the criteria for a new query. What I am trying to do is set up a query that the field "First" does not equal a value. When I enter a value as <>4 as the criteria then click run it returns a list where "first" does not equal 4.

But when I try using the tabe "List" as <>[List].[First] which equals 4. I get an error saying (could not update; currently locked by user '(unknown)' on machine ''.)

If you could help that would be great.