G Guest Jun 8, 2007 #1 Is it possible, without rounding, for a cell to display it’s contents only if the value within the cell is a whole number?
Is it possible, without rounding, for a cell to display it’s contents only if the value within the cell is a whole number?
J J Jun 8, 2007 #2 'Cell' is excel talk! We say 'Field' in access country. I recommend you use a query that has as one of its "Fields" be: Field1Fixed: Iif([Field1]=Int([Field1]),[Field1],"") or if you are actually asking if you can filter in only the rows that have whole numbers then under query CRITERIA you want: =Int([Field1]) Best of luck, ~J
'Cell' is excel talk! We say 'Field' in access country. I recommend you use a query that has as one of its "Fields" be: Field1Fixed: Iif([Field1]=Int([Field1]),[Field1],"") or if you are actually asking if you can filter in only the rows that have whole numbers then under query CRITERIA you want: =Int([Field1]) Best of luck, ~J
