CODEWITHSUNDEEP
ms-accessms-access-2010
Syed Alish Raza Naqvi
Syed Alish Raza Naqvi

Reputation: 83

Hide Zero Value Balance Row From Report In Ms Access 2010

I'm Working On A Project In Microsoft Access 2010 I'm Facing Some Issue And Can't Understand How To Solve I Tried Many Methods But Failed

In My Query [TQ]Total Quantity | [STQ]Total Sale Quantity | [RQ:][TQ]-[STQ]Remaining Quantity I Want To Remove If RQ Remaining Quantity Is 0 Then Not Showing In My Report With "YES" or "NO" Require

Here Is I Attached Screen Shot OF Query & Report

enter image description here

enter image description here

Please Anyone can Help Me For This Issue.

Thanks

Upvotes: 0

Views: 945

Answers (1)

Gustav
Gustav

Reputation: 55856

No formula is needed. Just apply this to the Format property of the textbox RQ in your report:

0,\-0,""

or, if semicolon is your local separator:

0;\-0;""

Upvotes: 1

Related Questions