A question about format property

[bkalimili]

I have 2 fields Credit and Debit created just in the query design,
They are just alias fields, not fields in the table.

I have a amount (field name amt_mntry) in the table gen_ledge_cct_details.

The logic is as follows:

IIf([gen_ledge_cct_details.amt_mntry]<0,[gen_ledge_cct_details.amt_mntry],0) AS Credit, IIf([gen_ledge_cct_details.amt_mntry]>0,[gen_ledge_cct_details.amt_mntry],0) AS Debit,

The amount field (field name amt_mntry) is present in the child subform.

I have the display fields for the credit and debits in the Main form or parent form.

My question is, right now the since they are alias fields in the query, I could just right click the field in the query and choose the format to be currency.

Since it is dealing with huge dollar amounts how should I say display the decimal 4. upto 4 values to right.
Since currency only displays 2 values after the decimal.

Thanks a lot.

 

[Rich]

set the decimal places to 4

 

[bkalimili]

thanks a lot.