Datatype problem

[Guest]

Hi,

I am using an create table qry base on an existing imported table with the
addition of two further feilds Expr1 and Expr2. problem I have is the
datatype of these feilds is set to binary after the query runs. I would like
them set to text and currency.

Anyone point me in the right direction as how to achieve this.

Thanks

 

[Jeff Boyce]

Don't use a make-table query. Instead, create a table definition with the
fields and data types you need, then create an append query to parse your
imported data into your permanent structure.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Check out the CStr and CCur functions in Help.

It would be something like CStr(Expr1) and CCur(Expr2) .

 

[Guest]

Hi,

thanks for that..it did point me in the right direction. I found that if I
right click in the Query Design window (in the show table area) I am able to
choose parameters. In the perameters box I can then use the name "type" and
set its property to text likewise I can do the same entry for "Cost" and set
it as currency.

(Expr1's name is type and Expr2 is cost.)

Then when the create table is run it creates these fields with the correct
datatype.