Hello,
I want to count fields that are blank. The fields I have are set as text so some that are blank, don't get counted because I guess it thinks there is something in them. Also, my count would be based on other fields also. Here's an example:
Field 1 field 2 field 3
Test 1/4/05
Test
Test 1/4/05
I want it to return a record ONLY if both fields 2 and 3 are blank. So the querie would return as follows:
Field 1 Field 2 Field 3
Test
The problem is I have some records that are blank, but it doesnt return them since it thinks there's something in them (I know this has to do something with it being a text field, just need it to stay a text field).
Thanks for the help in advance.
I want to count fields that are blank. The fields I have are set as text so some that are blank, don't get counted because I guess it thinks there is something in them. Also, my count would be based on other fields also. Here's an example:
Field 1 field 2 field 3
Test 1/4/05
Test
Test 1/4/05
I want it to return a record ONLY if both fields 2 and 3 are blank. So the querie would return as follows:
Field 1 Field 2 Field 3
Test
The problem is I have some records that are blank, but it doesnt return them since it thinks there's something in them (I know this has to do something with it being a text field, just need it to stay a text field).
Thanks for the help in advance.