Specific datatypes in Make Table Query

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

Re: Specific datatypes in Make Table Query

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

Re: Specific datatypes in Make Table Query

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.