I have an update query which includes several joined tables. The update simply updates a yes/no field in each table from 0 to -1 WHERE one of the tables' (called prospective brokers) records are equal to null. The problem is that I get a type conversion failure because some times some of the tables may not have a record to update. I am doing this in Access 97 within the query design view (i.e. I am not coding this!). Could some one explain how to get round this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to update when some joined tables do not contain a record?
- Thread starter JGKWORK
- Start date
hassanmfsa
MIS
Try this:
when you SELECT Field1 for example try to use the following for each of the fields you're selecting.
SELECT NZ(FIELD1,VALUE)
Field1 is the field that is null.
Value is the value you want to put instead of Null.
Value must be of the same type of Field1.
Regards, Hassan
when you SELECT Field1 for example try to use the following for each of the fields you're selecting.
SELECT NZ(FIELD1,VALUE)
Field1 is the field that is null.
Value is the value you want to put instead of Null.
Value must be of the same type of Field1.
Regards, Hassan
- Status
Similar threads
- Locked
- Question
- Locked
- Question
