Getting rid of 0's in report

[Emma]

Hi this is going to sound complicated. I have a report based on a query it
has two columns male and female. Unfortunately if the user forgets to check
male it returns a 0 and likewise for female. I just want to include the rows
where the male's a a1 value and females are a 1 value. Is there some VB that
can help me get rid of the 0's? And where do I put it in a report, I didn't
notice any onload.

 

[Roger Carlson]

More than likely, the default value for each of those fields is 0 (zero).
Go into the table design and remove that default value. That won't remove
the existing zero values, but it will keep any new ones from appearing.
Next, you'll have to do an Update query to set all the zero values to Null.
Something like this:

UPDATE YourTable SET YourTable.YourField = Null
WHERE YourTable.YourField=1;

Replace "YourTable" and "YourField" with your acutal table and field names.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[KARL DEWEY]

Post the SQL of your query by opening in design view, click on VIEW - SQL
View, highlight all, copy, and paste in a post.

Do you want to not display the complete record if Male = 0 or just show a
blank in the record?

Or not display the complete record if BOTH Male = 0 AND Female = 0?