View

[ACarella]

I am new to Access 2007. Every time I create a query and get it fine tuned,
and then save it and give it a name, then close out of it and then select it
to run again, everything that was in the query is gone and I am back to the
beginning where I have to add tables/colums, criteria, etc. What is going on?

I need criteria to run that will return either a space, blank, null value
for a column. How do I combine Is Null and =""

How do I delete all the queries that are just blank under the
Create/Other(Query Design) which are blank (even though when I created them,
they had selected field/column names and criteria

Thank you. Arlene

 

[KARL DEWEY]

I need criteria to run that will return either a space, blank, null value
for a column. How do I combine Is Null and =""

Do you want a column of blanks or return all records that have a column blank?

For a column of blanks add a field in the design view grid like this --
Some_Name: Null
OR
Some_Name: ""

For a column that is blank use this criteria --
Is Null OR ""

 

[ACarella]

Hi Karl:
I figured it out for access.
criteria is ="", that returns all the records that are blank for this
particular field.
Do you know the answers to my other two questions?
Thanks.

 

[KARL DEWEY]

Never had your other problem - cannot help.

But remember the a Null is not the same as "". Side-by-side quotes is a
zero lenght string or empty string which is not the same as a Null.