Re: How do I print a report without showing any zero fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Please find and turn off your CAPS LOCK. Use your shift key.

Do you want to filter out records with 0 or do you want to display a blank
or nothing where there is a value of 0? If you want to simply adjust the
formatting, use the format property. Check Help on formatting numbers to see
how to do this.

--
Duane Hookom
MS Access MVP


"DURASEAL ADMINISTRATOR" <DURASEAL ADMINISTRATOR@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:4057795F-4964-440F-9820-C0ED6C23B953@xxxxxxxxxxxxxxxx
>i HAVE A FORM THAT HAS CALUCATIONS THAT IN ORDER TO TOTAL, SOME INSTANCES
> REQUIRRES A "0" BE ENTERED WHEN THERE IS NO VALLUE IN ORDER FOR FORM TO
> TOTAL. I DO NOT WANT THIS "0" VALUE TO PRINT ON MY REPORT, HOW DO I
> FORMAT
> REPORT TO ONLY PRINT WHEN THERE IS A NUMERIC VALUE NOT WHEN "0"


.

Relevant Pages

  • RE: Access Report Filters
    ... The filter is correct to how it should look, ... Tested again and when the report opened it had no data. ... put the report into design mode then back to preview mode and the data was ... Tried formatting the dates to Us and UK but still get the same... ...
    (microsoft.public.access.reports)
  • Re: Merging with Access queries - Multiple
    ... Access Report to an .RTF file. ... > of the loss of formatting, fonts, etc.). ... Word can really only use a "flat file" as the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Maintain Formatting during copy paste
    ... Microsoft MVP (Word) ... "Suzanne S. Barnhill" wrote: ... report, if the document is blank the paste works fine, and no she does ... special formatting as she types. ...
    (microsoft.public.word.tables)
  • Re: How would the God of Standard Sql - Celko do server side paging?
    ... As I have said over and over, year after year, you do not do display ... And the hero in my war story was the Report Server guru, ... The database was choking to ... address, etc. formatting. ...
    (microsoft.public.sqlserver.programming)
  • RE: How do I make SQL within Code become report source
    ... When I took the formatting off the table, ... "Kenny A." ... There is no need to set the SQL of report because you want to change the ... You will change the SQL of the report if you want to change the Source table ...
    (microsoft.public.access.reports)