Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jun 25 16:06:32 CDT 2013
Absolutely correct if using the QBE grid. If you are building the SQL by hand, use "..Where fieldname IS NULL.." On 25 Jun 2013 at 11:54, Doug Steele wrote: > 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 > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >