wpkay
asked on
Getting value from a blank field of a database
my task is to get a value from several table let say table A, table B, table C and table D to a single table name table E.the problem that im facing now is that from these seperate table i need specific field from each of them and insert it into table E.i cant insert a blank/null value (field) from table A,B,C,D to a field in table E.the field that need in table E,must be fill up and cant be left blank/null or else error will occur.
e.g.:
Set rs1 = adoconn.Execute("SELECT PrinOut FROM Provision WHERE MasterAcNo in (SELECT MasterAcNo FROM account_Holder WHERE CustNo = '" & Trim(rs!CustNo) & "')")
rs1!PrinOut = Null
error prompt out:
the table cannot be zero-length.
due to this program is a data checking program, i cant make modification on the table on the field cos' all the fields in the table E is compulsory.
wat is the method or way that can help me solve this problem?
e.g.:
Set rs1 = adoconn.Execute("SELECT PrinOut FROM Provision WHERE MasterAcNo in (SELECT MasterAcNo FROM account_Holder WHERE CustNo = '" & Trim(rs!CustNo) & "')")
rs1!PrinOut = Null
error prompt out:
the table cannot be zero-length.
due to this program is a data checking program, i cant make modification on the table on the field cos' all the fields in the table E is compulsory.
wat is the method or way that can help me solve this problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
per recommendation
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Accept ryancys's comment(s) as an answer.
wpkay, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you. DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer