Query not returning records properly

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello. My problem. I have a table in which one of the
fields is a text formated field. it contains data such
as "2001-100" "2003-132.04" or "2002-307.09.1" (without
the quotes) Problem is, when I run a query that asks for
input (search string) from this field in the table, the
results are correct for the first two data items listed,
but not the 3rd (2002-307.09.1). for that, it comes up
empty even though there's a record in the table. could it
have to do with the double decimal? that's the only
difference. The field lenght in the table is 50, so its
not a truncation issue. Any help? Jim.
 
G'day Jim,

If you would care to e-mail me a docment with screen
prints of your Query design and of the Query result, plus
the part of the Table in Design view with the relevant
part of the properties/design selected, I'll have a look
and see what I can come up with.

Cheers,

Heather. :-)
Melbourne, Victoria, Australia
 
Back
Top