Hail,
I have to 2 number fields which I want to display in a query with a calculation as Field1 / Field2 but instead of integers I want the field to show two decimals. So I thought I could use format(a,"0.00") or #.## but then when I put a sort on that field, it screws it up because it treats it as a text field (i.e. 11.50 comes before 9.50)
Am I just forgetting something, I have a feeling it's something really simple!
Phailak
I have to 2 number fields which I want to display in a query with a calculation as Field1 / Field2 but instead of integers I want the field to show two decimals. So I thought I could use format(a,"0.00") or #.## but then when I put a sort on that field, it screws it up because it treats it as a text field (i.e. 11.50 comes before 9.50)
Am I just forgetting something, I have a feeling it's something really simple!
Phailak