Null Values In Summarized Report

[Mickey Wells]

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

 

[Allen Browne]

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.

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 Wells]

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

 

[Allen Browne]

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