Make Table Query question

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

Joe Blow

Hello all:

Access 2003...

Why is it, that when I do a make table query, and I set the properties of a
field to "Currency",
that the field type in the table is still "Number"?

-Joe
 
Joe Blow said:
Why is it, that when I do a make table query, and I set the properties of a
field to "Currency",
that the field type in the table is still "Number"?
Click to expand...

Try putting a ccur() around that field and see if that helps.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

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

Make Table Query Question 1
Lookup query allows me to retrieve up to two rows. 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Data Type Changes when linking excel 2
Rounding in Update Query 3
no matching field for 1-many relationship and erratic query 1
Run Queries on Related Tables 3
Preventing rounding numbers to nearest dollar 2

Back
Top