sportsguy
Finance wiz, Access hack
- Local time
- Today, 04:01
- Joined
- Dec 28, 2004
- Messages
- 358
I have linked an excel spreadsheet within access, and a particular field is formatted as data. If one of the column cells is MT, (empty), then the view returns #num error.
Question is how to trap that error to convert to a date or null, or something else?
thanks in advance. . .
sportsguy
Question is how to trap that error to convert to a date or null, or something else?
thanks in advance. . .
sportsguy