Field format in make table query

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

How can I change a "currency" field to export as a general number in a make
table query?
 
What do you mean by General Number? Do you want to drop the formatting? Do you
want just the integer portion?

Post a few examples of what you are getting when you export and what you want
those to be.
 
Specifically, I have a make table query that I then use a transfer text
macro to create a text file. The table that I am reading in the make table
query has a field that is defined as currency. (e.g. $2.57). When I do the
transfer text, I want the final value in the text file to read 2.57 without
the "$" sign.

Thanks,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Field's Precision Too Small to accept the numeric you ... 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Make table query: [Enter 1] AS Test 1
Changing the format of a field while doing a make table 1
format field in make table query 2
How do I get Access to append the exact amount with decimals? 2
Query Field Format 2
Two tables, multiple relationships? 1

Back
Top