Create a query.
In the Criteria row under this field, enter:
Is Null Or <"N/A"
Save the query.
Set the RecordSource property of your report to this query.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Steven" <sc*****@verizon.netwrote in message
news:mK9_h.6480$2V1.4610@trnddc08...
Hello,
I have a field of Name and its data are different insurance company names,
but there is a "N/A" standing for those folks without insurance.
Using a query/report, I want the records with "N/A" not shown, how do I do
that? Any string comparison?
Any help is appreciated!
Ste