I have a query that is joining four tables. The first two tables join on a sale identifier (text), the second and third table join on a customer number (number) and the third and fourth table join on the customer number to get a zip code.
Some of the zips are null so I supplied this code to supply 99999 where the zip code is null-- ZIP: IIf([ZIPCODE] Is Null,'99999',[ZIPCODE])
A lot of 99999 entries were returned, when we should have only had a few.
While troubleshooting, I simply put a sale identifier, that had returned 99999 in the ZIP column, in the criteria box of the query, and low and behold the proper zip code was returned!
This query worked before the underlying database (SQLServer) was upgraded from 6.5 to 7.
Any thoughts?
This doesn't make any sense to me.
Ken
Some of the zips are null so I supplied this code to supply 99999 where the zip code is null-- ZIP: IIf([ZIPCODE] Is Null,'99999',[ZIPCODE])
A lot of 99999 entries were returned, when we should have only had a few.
While troubleshooting, I simply put a sale identifier, that had returned 99999 in the ZIP column, in the criteria box of the query, and low and behold the proper zip code was returned!
This query worked before the underlying database (SQLServer) was upgraded from 6.5 to 7.
Any thoughts?
This doesn't make any sense to me.
Ken