Report and subreport

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

Guest

Dear Sirs
I have a report with a subreport. I would like that, if the field "deposit",
in the subreport, is showing a zero, the record should not be shown on the
subreport.
How can I do that?
Thanks
Klaus
 
You can base the subreport on a query that uses >0 (or <>0) as the criteria
for the Deposit field.
 
Amatuer,
You would filter out those records via the Deposit criteria in the query
behind your report.
From what you indicated... this criteria
Deposit <> 0
would filter out all records with a value of 0 in the ceposit field.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
 
No problem. It was my choice to answer the question. Your brain got full,
and the solution was hiding, that's all. It happens to just about everybody
at some time and on some level.
 
Back
Top