Not getting the last Zero's

  • Thread starter Thread starter Bob V
  • Start date Start date
B

Bob V

If my result is $1,500.00 I am getting this $1,500.
="Grand Total: $" &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
[tbOwnerID].[Value]),"")),"#,###.##")
Any Help Please...............Bob
 
Hi -

Change your statement to this:


="Grand Total: " &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
[tbOwnerID].[Value]),"")),"$#,##0.00")

Note that the $ is now in the format statement.

That should do it.

John


Bob said:
If my result is $1,500.00 I am getting this $1,500.
="Grand Total: $" &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
[tbOwnerID].[Value]),"")),"#,###.##")
Any Help Please...............Bob
Click to expand...
 
Brilliant thanks for the help...........Bob :)

J_Goddard via AccessMonster.com said:
Hi -

Change your statement to this:


="Grand Total: " &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
[tbOwnerID].[Value]),"")),"$#,##0.00")

Note that the $ is now in the format statement.

That should do it.

John


Bob said:
If my result is $1,500.00 I am getting this $1,500.
="Grand Total: $" &
Format((NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
[tbOwnerID].[Value]),"")),"#,###.##")
Any Help Please...............Bob
Click to expand...
Click to expand...
 
Back
Top