J
Joseph Moraise
dear friends,
please any one can advise me to how to pass null value to
a stored query in access. i created an append query in
access, the values are passing through paramters. the
table is having 2 foriegn key constraints with other two
table. so when i am executing queries, for the reference
fields i am passing empty string , but raise an error says
a reference record should exist in the reference table.
please help out to solve this problem. i hope if i am able
to set the field value as null constant( like normal sql)
it will work. but i don't know how?
with regards
Joseph Moraise
please any one can advise me to how to pass null value to
a stored query in access. i created an append query in
access, the values are passing through paramters. the
table is having 2 foriegn key constraints with other two
table. so when i am executing queries, for the reference
fields i am passing empty string , but raise an error says
a reference record should exist in the reference table.
please help out to solve this problem. i hope if i am able
to set the field value as null constant( like normal sql)
it will work. but i don't know how?
with regards
Joseph Moraise