Printing report in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have design a table to enter data picking specific info w/o duplicates. Table works. However when I'm done and want to print, I want to suppress records with blank fields on my report. Report changes daily

How can I complete my table and then run a report supressing records with blank fields

In Excel, I can't eliminate the duplicate choices but I can use Data Filter to key on "non blanks

Please send me possible solutions.
 
Without knowing the specifics, my guess would be to create
a query and specify "is not null" for the appropriate data
elements. The other option is to set the textboxes in the
report to can shrink - yes and the appropriate report band
also to can shrink - yes.
This should eliminate most blanks (if not all) from your
reports.
Hope this helps.
Fons
-----Original Message-----
I have design a table to enter data picking specific info
Click to expand...
w/o duplicates. Table works. However when I'm done and
want to print, I want to suppress records with blank
fields on my report. Report changes daily.
How can I complete my table and then run a report
Click to expand...
supressing records with blank fields?
In Excel, I can't eliminate the duplicate choices but I
Click to expand...
can use Data Filter to key on "non blanks"
 
Back
Top