Doug Steele
dbdoug at gmail.com
Tue Jun 25 13:54:01 CDT 2013
John, I don't think you need the field name when testing for null in the criteria section: Is Null or ="" Doug On Tue, Jun 25, 2013 at 11:40 AM, John Clark <John.Clark at niagaracounty.com>wrote: > (Resending because I neglected to change the subject line...) > > So, I'm having a bit of an issue w/a small A2010 program I recently wrote. > There are a couple of issues, but one, which I thought would be a simple > one, has really ticked me off today. > > There are several blank records that need to be gone. This is actually a 2 > part problem, because some of them (11) are completely blank, but the > majority of them (24) were assigned voucher numbers, but have no other data. > I think I understand the latter...I assign that number immediately, so if > someone clicks to add a new records and does not, or maybe they're hitting > the button twice...and I did not have any validation for that event...then > I could see a record number w/out any data. But, given what I just said, I > do not understand having a record w/no voucher number or data. > > Anyhow, having said all of this, what I really want to do right now is to > week out those records...get a list, using a query, before deleting > them...to make sure my numbers come out right. I figured this was going to > be as simple as either putting IsNull(field) in the criteria section...to > be sure I was actually going to do 4 fields to be sure....or check for = > "". But, neither of these is working and I'm getting 0 records. > > I surely must be forgetting something...making a bone head move somehow. > Can someone please set me straight? > > Notice: This electronic transmission is intended for the sole use of the > individual or entity to which it is addressed and may contain confidential, > privileged or otherwise legally protected information. If you are not the > intended recipient, or if you believe you are not the intended recipient, > you are hereby notified that any use, disclosure, copying, distribution, or > the taking of any action in reliance on the contents of this information, > is strictly prohibited. Niagara County is not responsible for the content > of any external hyperlink referenced in this email or any email. > IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER > IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER > OR ELECTRONIC COPIES. > Thank you for your cooperation. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >