Number to Currency

[Guest]

Hi,

I had set field properties in a query to currency, but after Make-table the
value in table doesn't show in currency, in table Data type show Number...!!

PLEASE HELP...!! new uses

 

[John Spencer]

IF you are using a Make Table query, then you can force the data type using
CCur in the data field. The format property of the field in the query grid
has no effect on the creation of the table when you use a Make-table query.

Try something like:
Field: DesiredFieldName: CCur(CurrentField)

And if the CurrentField has nulls, you will probably need
Field: DesiredFieldName: IIF(CurrentField Is Null, Null,CCur(CurrentField))

Make table queries are seldom needed and even when they may be "needed".
You are usually better off constructing an empty table in advance where you
can control data types and indexes and then populating the table with an
append query. When you need to reuse the table, use a delete query to clean
it out.

Advanced technique if you need the table only temporarily, might be to build
an empty query and then copy it into a temp database, link to the table in
the temp database, and populate the the table, use it and then destroy the
temp database when you are finished working with it.

Check out Tony Toews article on this at
http://www.granite.ab.ca/access/temptables.htm

 

[John Vinson]

Hi,

I had set field properties in a query to currency, but after Make-table the
value in table doesn't show in currency, in table Data type show Number...!!

Just as another thing to consider:

MakeTable queries are rather rarely actually needed.

You can create a Select Query based on your table (or a combination of
tables). This Query can be used as the recordsource for a Form or a
Report; it can be exported; it can be used as the basis of a listbox
or combobox; it can be used as the basis for another query.

Often running a MakeTable query just adds complexity and overhead, and
doesn't give you anything you can't do more simply!

John W. Vinson[MVP]