I have people throwing all kinds of junk in a basic text field where they should be entering an actual number. (This is another program not contolled by me because OF COURSE i would change that!!!!) When the data is returned in my query, I want to take those numbers and do a simple [FIELD] * 1 to convert it to an actual number to join it to another query. Because of the garbage, i return errors on some of the rows. I thought a simple formula simlar to what i would use in excel would do the trick. alas, it’s not working as i expected. can someone help get me over my stumbling block? As always, thanks!
IIF(ISERROR([field] * 1),””,[field] * 1)
