How do you specify a range of fields in a query??

[coder30]

I am trying to check 25 fields for null values is there a way to say... "iif([fieldeG] through [fieldZ]is null,1,0)

 

[lespaul]

no, you will need to write each one individually.

Is your table committing spreadsheet?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[Remou]

What did you want to use? A form or a recordset? For example:

For Each fld In rs.Fields
    If IsNull(fld) Then
        Debug.Print "Is Null"
    Else
        Debug.Print "Is Not Null"
    End If
Next

 

[coder30]

Thanks leslie.

Remou - that would work if the fields were truly null, but I've just discovered some of the fields contain spaces, so they aren't truly null.

 

[JerryKlmns]

How about

UPDATE myTable SET myField = Trim(myField)

to get rid of only-space fields and get NULL?

 

[Remou]

You will often see Trim(Field & " ") = "" used in these fora as it test for null, spaces and zero length strings.

 

[coder30]

Thanks!... I think that will work!