How do I select a record(s) from a table that are not Null or spaces.

Maybe:

......Where Field1 Is Not Null Or Field1 <> ''

Thanks

If your field contain space (I mean one space, 2 spaces, ...), you can use

where NZ(trim(Field1),"") <> ""

But if your space mean Zero Length String, you can use shorter form

where NZ(Field1,"") <> ""

HTH

Works fine. Thank you.