Query and reports "Show"

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

Guest

I have a query that has many fields that I am running reports off of. I have
it suming one of the fields (Defects) when (Action Required) = true. The
problem is that it lists the other (Defects) as well. Do I have to have a
seperate query to show just the action required or is there a statement for
show only if Action Required = true?
 
I have a query that has many fields that I am running reports off of. I have
it suming one of the fields (Defects) when (Action Required) = true. The
problem is that it lists the other (Defects) as well. Do I have to have a
seperate query to show just the action required or is there a statement for
show only if Action Required = true?
Click to expand...

post the query your report is based on and the filter you're using
when you open the report. You would probably be better off filtering
the report in the Open event...
 

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

Query 2
Update a field in a table based on two other fields 2
Query will only show data for first record 1
Passport date checker 1
How to get count of unique records in one-to-many query 3
Running Total in SQL query not working as needed 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Why's my query doing this? 2

Back
Top