var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Import Number With Following Sign
I wish to import a txt file where the numbers have a sign (-) following the numbers. How do I get Access to recognize this as a negative number during the import?
should swap trailing to leading "-" (where "-" exists) in text and convert the text to double.
=cdbl(iif(right$([fieldName],1)="-", "-" & left$(len([fieldName])-1), [fieldName]))
so import as text to a temp table and use the above expression in a make table query.
How you have a great week!!!