|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Number Overflow Error on Text FileI have a linked table to a text document (.txt) that I add to on a daily basis. The text document holds date (mm/dd/yyyy format) and a bunch of other information. I set up a query to look at this linked table and give me information. On my query, i have a field that is set up for date and my criteria says the following : Between [mm/dd/yyym] and [mm/dd/yyye]... which is my parameter to see the specific dates. When I run this query i get the following Numeric Erro :This error may be caused by a Numeric Field Overflow and only appears if a field in a table is linked to a Windows SharePoint Services site or Btrieve database. In either case, the error occurs when you provide a field value that is invalid for the corresponding field type - for example entering a 10-character string in a field designed to hold only 5-characters.:etc etc etc. Any idea why and how to fix this problem. Thank you everyone again!!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200711/1 Is the field you are retrieving from a "text"-type field, or a
Date/Time-type field, or a numeric-type field? You're probably getting the overflow because you are dividing mm by dd and that by yyyy (Access is treating the m/d/y separators as division). Regards Jeff Boyce Microsoft Office/Access MVP "instereo911 via AccessMonster.com" <u27979@uwe> wrote in message news:7b51056d90ecd@uwe...Show quote > Good afternoon, > > I have a linked table to a text document (.txt) that I add to on a daily > basis. The text document holds date (mm/dd/yyyy format) and a bunch of > other > information. > > I set up a query to look at this linked table and give me information. On > my > query, i have a field that is set up for date and my criteria says the > following : Between [mm/dd/yyym] and [mm/dd/yyye]... which is my parameter > to > see the specific dates. > > When I run this query i get the following Numeric Erro :This error may be > caused by a Numeric Field Overflow and only appears if a field in a table > is > linked to a Windows SharePoint Services site or Btrieve database. In > either > case, the error occurs when you provide a field value that is invalid for > the > corresponding field type - for example entering a 10-character string in a > field designed to hold only 5-characters.:etc etc etc. > > Any idea why and how to fix this problem. > > Thank you everyone again!!! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200711/1 > Thanks for responding Jeff,
The field i am retrieving is date/time field - If this is right,When i input my parameters, how do i input the date if not by mm/dd/yyyy? Thanks again for the help. Jeff Boyce wrote: Show quote >Is the field you are retrieving from a "text"-type field, or a >Date/Time-type field, or a numeric-type field? > >You're probably getting the overflow because you are dividing mm by dd and >that by yyyy (Access is treating the m/d/y separators as division). > >Regards > >Jeff Boyce >Microsoft Office/Access MVP > >> Good afternoon, >> >[quoted text clipped - 23 lines] >> >> Thank you everyone again!!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200711/1 You may need to surround the values you put it with the delimiters that tell
Access you are using dates (i.e., the "#" signs). If you are working in a query, you can add a parameter to the query itself, and TELL Access that it is a Date/Time value. Regards Jeff Boyce Microsoft Office/Access MVP "instereo911 via AccessMonster.com" <u27979@uwe> wrote in message news:7b52d0d6a0b3f@uwe...Show quote > Thanks for responding Jeff, > > The field i am retrieving is date/time field - > > If this is right,When i input my parameters, how do i input the date if > not > by mm/dd/yyyy? > > Thanks again for the help. > > Jeff Boyce wrote: >>Is the field you are retrieving from a "text"-type field, or a >>Date/Time-type field, or a numeric-type field? >> >>You're probably getting the overflow because you are dividing mm by dd and >>that by yyyy (Access is treating the m/d/y separators as division). >> >>Regards >> >>Jeff Boyce >>Microsoft Office/Access MVP >> >>> Good afternoon, >>> >>[quoted text clipped - 23 lines] >>> >>> Thank you everyone again!!! > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200711/1 > I think Jeff is right! Access treats
11/16/00 as 11 dived by 16 divided by 00 which will bomb! #11/16/00# on the other hand, is recognized by Access as a date -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200711/1  |
|||||||||||||||||||||||
Other interesting topics