I have a database that runs a number of queries from a linked Excel file. In the Excel file there are some fields/columns that are in the currency format. When I build tables in Access, I want to have a numeric field with two decimal places rather than a currency field.
I've tried formatting the fields in my make-table query to standard, with two decimal places. When I go to the datasheet view, the numbers appear how I want them. However, when I run the query and build the table, the numbers in the table are in the currency format.
How can I force the format to be like I want it from my make table query? I've tried going into the table and changing the format and then rerunning the query, but it still goes back to currency format (as it is in the Excel file that is linked).
Can anyone help?
I've tried formatting the fields in my make-table query to standard, with two decimal places. When I go to the datasheet view, the numbers appear how I want them. However, when I run the query and build the table, the numbers in the table are in the currency format.
How can I force the format to be like I want it from my make table query? I've tried going into the table and changing the format and then rerunning the query, but it still goes back to currency format (as it is in the Excel file that is linked).
Can anyone help?