create a temporary table so that I can convert the text fields with
numeric values to a currency format but I am receiving an error
stating that it can't convert and it is making all the numeric values
null.
For instance the linked spreadsheet has three fields, totalValue,
Cost, Compensation all of which are text fields, I set these to be TV
= ccur([totalvalue]), CT = ccur([cost]), and Compens = ccur
([compensation]) and it is erroring me out stating that it could not
convert the text field to a numeric value.
Am I missing something?
Thanks
Eileen
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
