Controlling Make-table data types

[jclark33]

I have created a make-table query that pulls vendors from the current month, prev month, and three months past. I am using another query to pull from that the current top ten and do some calculations based on the past data. My problem is this when the make-table querie runs, it generates a field I need to sum, with a text-datatype, and i get an aggregate function error. Can I control the datatypes with in the table the query generates?

thanks

 

[jclark33]

figured it out, i just ran a delete qry then appended whats necessary.

thanks for the help

 

[akt01]

Is there an answer to the original question:

Is it possible to program a make-table query to define the datatypes for the fields in the new table?

If not, is it possible to write code to change field types and sizes?

Thanks for any help

 

[FISHiEE]

That solved my problem also. Cheers for that Pat!