By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

Specific datatypes in Make Table Query

P: n/a
Hi,

Working with a database that's new to me and they have a make table
query that creates a variety of fields, a handful of which are
designated as datatype 'Number' to start. It is then required to go
change many of these to datatype 'Currency'. How can specify those
fields to be 'Currency' from the start? The reason for doing so is
that I believe it may overcome an intermittent rounding error that
occurs.

Any help is appreciated!

Kindly,

Michael
Dec 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Dec 19, 5:17 am, mfsfor...@gmail.com wrote:
Hi,

Working with a database that's new to me and they have a make table
query that creates a variety of fields, a handful of which are
designated as datatype 'Number' to start. It is then required to go
change many of these to datatype 'Currency'. How can specify those
fields to be 'Currency' from the start? The reason for doing so is
that I believe it may overcome an intermittent rounding error that
occurs.

Any help is appreciated!

Kindly,

Michael

Use the ccur function to convert a field in your make table query to
currency, e.g. use something like:

SELECT a, ccur(oldtable.b) as b into newtable
from oldtable
Dec 19 '07 #2

P: n/a
On Dec 19, 9:25 am, helenwhee...@yahoo.com.au wrote:
On Dec 19, 5:17 am, mfsfor...@gmail.com wrote:
Hi,
Working with a database that's new to me and they have a make table
query that creates a variety of fields, a handful of which are
designated as datatype 'Number' to start. It is then required to go
change many of these to datatype 'Currency'. How can specify those
fields to be 'Currency' from the start? The reason for doing so is
that I believe it may overcome an intermittent rounding error that
occurs.
Any help is appreciated!
Kindly,
Michael

Use the ccur function to convert a field in your make table query to
currency, e.g. use something like:

SELECT a, ccur(oldtable.b) as b into newtable
from oldtable
I should add that this'll just do the conversion - it may not sort out
your rounding error. If the rounding problem is happening before you
do the make table you'll just end up with a wrongly rounded number of
currency type.
Dec 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.