Results from criteria field incorrect although syntax used are the

[Guest]

I am a new user of Access and would appreciate any help out there.

In my query, I have the following fiields: Date of Claim, Paid / Unpaid. If
unpaid, then the query would provide me with an aging, where in I would
receive the number of days the Date of Claim has been pending, relative to
the current date.

Using the criteria field, I have successfully displayed records less than 30
using: <"30" And Not "Paid". However, when I changed the number to "60", the
query gave me incorrect results.

To test the query further, I used between "300" and "360" And Not "Paid" and
received correct data. It was only using <"90" and <"60" that I received
incorrect results.

Can anybody please help me with this?

 

[Guest]

Thanks much! Peace.

It's look like you are using text as criteria, in that case

with text criteria 9 is greater then 600, it will compare first the first
chr only and then the second

You need to convert the text to number and then use the criteria

Where Val([FieldName]) < 60

--
\\// Live Long and Prosper \\//
BS"D

I am a new user of Access and would appreciate any help out there.

In my query, I have the following fiields: Date of Claim, Paid / Unpaid. If
unpaid, then the query would provide me with an aging, where in I would
receive the number of days the Date of Claim has been pending, relative to
the current date.

Using the criteria field, I have successfully displayed records less than 30
using: <"30" And Not "Paid". However, when I changed the number to "60", the
query gave me incorrect results.

To test the query further, I used between "300" and "360" And Not "Paid" and
received correct data. It was only using <"90" and <"60" that I received
incorrect results.

Can anybody please help me with this?