Report and subreport

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
 
B

BruceM

You can base the subreport on a query that uses >0 (or <>0) as the criteria
for the Deposit field.
 
A

Al Campagna

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

BruceM

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.
 

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

Report and subreport question 2
Report asks for Parameter and Won't Display Subreport 7
Error from Subreport 2
Rendering Subreport w/Columns? 2
Subreport problem 3
Display "No details" if subreport has no records 1
Reports and SubReports Spacing 6
SubReport - Two Questions 11

Top