Do I have to put something in there, such as "unk" for unknown, in order to use it as a criterion? It's already a large database, and that would be time consuming. Well, OK, then how do I do that automatically, if that's what I need to do?
2006-07-26 00:34:36 · 5 answers · asked by auntb93again 7 in Computers & Internet ➔ Software
set th criterion as equal to NULL
2006-07-26 00:38:14 · answer #1 · answered by Ivanhoe Fats 6 · 3⤊ 0⤋
It depends on the data format, in many cases it's Null but for text sometimes it's "" and for numbers other times it's 0. I'm sure someone knows what situation each arises, but I just experiment until it works.
On the "" there should be no space between the apostrophes that will set the criterion as single space.
2006-07-26 02:44:51 · answer #2 · answered by Dane_62 5 · 0⤊ 0⤋
hi, you may want to favor to make sparkling somewhat. Which of those sounds more effective like your difficulty: a million) the kind's record source is a table, and the issue is that you're unable to CREATE a sparkling record utilising the kind until eventually you enter records into each and every of the kind fields. 2) the kind's record source is a question that retrieves records from a table (or tables), and the issue is that the question isn't getting each and every of the information that you want -- so as that when you open the kind no longer each and every of the information are there.
2016-11-26 00:34:14 · answer #3 · answered by giraldo 4 · 0⤊ 0⤋
Haven't done it in a while but I think it is " ". ( a space between the apostrophes).
2006-07-26 00:38:59 · answer #4 · answered by Anonymous · 0⤊ 0⤋
NULL
2006-07-26 00:38:55 · answer #5 · answered by george_the_cat 2 · 0⤊ 0⤋