numeric overflow error and forms

[kerrigirrl]

i created a new make table query, ran it from the query tab and it ran fine. then i tried opening it from a form and running it from there and i got a numeric ovreflow error. when i tried running it from the query tab again, it kept giving me the same error.

has this happened to anyone else? i only have date/time and text fields in the table i'm using and they all look good.

any suggestions?
kerri

 

[tlbroadbent]

When you start the query the 2nd (3rd, 4th, ...) time, does it ask if you want to delete the existing table? Or does it error before that happens? Terry

;-) "When I hear somebody sigh, 'life is hard', I am always tempted to ask, 'compared to what'?" - Sydney Harris

 

[kerrigirrl]

the error happens after it deletes the table.

 

[tlbroadbent]

Could you post the SQL statement, please?

Thanks, Terry

;-) "When I hear somebody sigh, 'life is hard', I am always tempted to ask, 'compared to what'?" - Sydney Harris

 

[kerrigirrl]

SELECT JST_D01135.JobNum, JST_D01135.ProdCode, JST_D01135.JobName, JST_D01135.Quantity, JST_D01135.Pricing, JST_D01135.RecDate, JST_D01135.EstRelDate, JST_D01135.ActRelDate, JST_D01135.EstMailDate, JST_D01135.ActMailDate, JST_D01135.AcctSup, JST_D01135.MksRep, JST_D01135.InptRep, JST_D01135.QCRep, JST_D01135.SalesPerson, JST_D01135.UpdDate INTO JT2001
FROM JST_D01135
GROUP BY JST_D01135.JobNum, JST_D01135.ProdCode, JST_D01135.JobName, JST_D01135.Quantity, JST_D01135.Pricing, JST_D01135.RecDate, JST_D01135.EstRelDate, JST_D01135.ActRelDate, JST_D01135.EstMailDate, JST_D01135.ActMailDate, JST_D01135.AcctSup, JST_D01135.MksRep, JST_D01135.InptRep, JST_D01135.QCRep, JST_D01135.SalesPerson, JST_D01135.UpdDate;