Modify report

  • Thread starter Thread starter jshelp
  • Start date Start date
J

jshelp

I have just made a report after linking to a database. There are
various qty's in the finished parts feild, I would like to only
display quanitity greater than zero? Thanks in advance for any help...

Jack
 
You need to add criteria to the query to select only rows where the finished
parts field is > 0. If the report is not already based on a query, make one
with the criteria and replace the table name in the report's RecordSource
with the name of the query.
 
You must log in or register to reply here.

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

How hide value on report if certain criteria exists 1
Filtering data before displaying report 1
How do I create a report based off of several Combo Box selections 4
averaging a field value if field value is greater then 0 access report 4
Sorting within a Report 1
totals from a report 1
How to create a report in Access that would use a date range 8
Arithmetic in reports 2

Back
Top