Search results

Sorry- Should have been more clear with my fields. The below is the calculated field in my query which I am looking to identify as either an integer or decimal. Layers: [Past 90 Days April]![INTORG]/[Item Master]![Layer] In a subsequent field, I am looking to have the numbers from the...

I currently have a calculated field that will result in either a whole number or a decimal. From there, I need to set up a field that identifies if the previous field is either a whole number or a decimal. I have tried several different formulas, but always seem to get an error or a query that...