Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

numeric overflow error and forms

Status
Not open for further replies.

kerrigirrl

Programmer
Mar 29, 2001
39
US
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
 

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
 

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
 
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;

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top