Number Overflow Error on Text File

[instereo911 via AccessMonster.com]

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

 

[Jeff Boyce]

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]

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.

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

 

[Jeff Boyce]

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

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.

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

 

[Linq Adams via AccessMonster.com]

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