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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup for Report! 4
Change to report code needed 3
Adding a Blank between Names! 1
DLookUp Code! 7
First Character of First Name! 5
Format on report Problem 4
Help with a DLookUp 3
Text Box option to show Blank 8

Back
Top