Access 2007: We have a query that performs a simple sum of two fields from two tables. But some of these fields are text and only a "X" can be entered. So, if the user enteres a negitive x (-x) we need this field to return null. Is that possible?
This works, you can replace the x with what ever text data you are using: