Null Values In Summarized Report

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

Guest

I have a report that feeds off quite a few detailed queries and can not go in and modify the queries easily. I am needing to take current summarized report and exclude the line if both value in the three columns = 0

I am not extremely familiar with the code with access so any help is appreciated however please do not get to high tech on explainations as you will loose me

Mickey
 
Mickey, if you don't want to modify your existing query, you may still be
able to query the qeury.

Open your report in design view.
In the Properties of the report (Data tab), change the RecordSource property
to:
SELECT * FROM MyQuery WHERE NOT ([Field1]=0 AND [Field2]=0 AND
[Field3]=0);

If the fields contain some nulls, you may need to permit them also.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mickey Wells said:
I have a report that feeds off quite a few detailed queries and can not go
Click to expand...
in and modify the queries easily. I am needing to take current summarized
report and exclude the line if both value in the three columns = 0.
I am not extremely familiar with the code with access so any help is
Click to expand...
appreciated however please do not get to high tech on explainations as you
will loose me.
 
I keep getting a syntax error on Punctuation is incorrect. This is what I have typed:
SELECT * FROM Forecast 99 Rev WHERE NOT ([Current BO]=0 AND [Current BO Rev]=0 AND [Family]=0)

Thanks for your help
Mickey
 
Is "Forecast 99 Rev" the name of a table/query?

Add square brackets around any name that contains spaces:
SELECT * FROM [Forecast 99 Rev] WHERE
 
Back
Top