Calculated Qry Field Format in Rpt

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

This seems like it should be simple...

Access 97. I have a claculated field in a query that
returns a number from a mathmatical formula. The numbers
are generally large with lots of decimal places. I want
the number to display in the report in scientific
notation. I've encountered the following problems:

1) The format property for the field in the query is set
to Scientific. When I run the query the results are just
a long number.

2) The drop-down list in the format property for the
field in the report is empty.

3) I can't find any reference to how to manualy format
the field.

Can anyone help me with this?

Thanks,

Wayne
 
Thanks that works! I had failed to mention that I had the
calculation nested in an IIF statement that would return a
string if no data or the calculation results. It doesn't
like the string result. So I just have it return a 0 if
no data and the entire IIF statement is in the CDbl().

Thanks again for your help!

Wayne
 
Back
Top