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: IIf([field1]="x" And [field2]="-x",' ','x')– LtDanAug 28, 2012 at 20:48
-
If you found a solution, you should consider "answering" your own question when enough time has passed.– JoshPAug 29, 2012 at 14:42
Add a comment
|
1 Answer
This works, you can replace the x with what ever text data you are using: IIf([field1]="x" And [field2]="-x",' ','x')
– LtDan Aug 28 at 20:48