Is it possible to output a one-record result to a variable?
Basically, since Access doesn't support an "UPDATE table SET field = (SELECT value FROM...)" statement, I need milestone values to make progress.
Or is there a better solution?
I have a two-tiered table, one root, and zipcodes to zones.
When the zipcode is entered in the form, the zone should update. I've tried LEFT joining the tables initially, but people have their standards of using 5- vs. 9-digit zipcodes. [sig][/sig]
Basically, since Access doesn't support an "UPDATE table SET field = (SELECT value FROM...)" statement, I need milestone values to make progress.
Or is there a better solution?
I have a two-tiered table, one root, and zipcodes to zones.
When the zipcode is entered in the form, the zone should update. I've tried LEFT joining the tables initially, but people have their standards of using 5- vs. 9-digit zipcodes. [sig][/sig]
