L
Lou
Hello!
I have 2 tables linked to a DBII Database. On the name
cell it is assigned 30 characters for size. I take this
information form the linked table and update another table
in my dbase, mr problem is that the name cell is not
recognizing as null, since it is set for 30 characters it
is bringing in 30 blank spaces on the update and my
reports are not correct.
How can I either stop it from updating the 30 blank
characters or recognize them to change it so I can use the
Is Null or Is Not Null in my criteria?
Any suggestions would be great.
Access 2002
Thank you.
Lou
I have 2 tables linked to a DBII Database. On the name
cell it is assigned 30 characters for size. I take this
information form the linked table and update another table
in my dbase, mr problem is that the name cell is not
recognizing as null, since it is set for 30 characters it
is bringing in 30 blank spaces on the update and my
reports are not correct.
How can I either stop it from updating the 30 blank
characters or recognize them to change it so I can use the
Is Null or Is Not Null in my criteria?
Any suggestions would be great.
Access 2002
Thank you.
Lou