Access not recognizing balances >0

[ruggierm1]

I have been using Access since 1997 and have come accross a rather unique situation.

I currently have a table that has balances that are greater than 0 and balances that are less than 0. This table also has a field that applies a label to the age of the balance. for example, if it is 28 days old, it is in the "0-30" bucket, 31 days old, in the "31-60" bucket, and so on up until the "366over" bucket.

When I run a query, trying to capture the balances greater than 0 for the "366over" bucket, it returns exactly that. When I try and summarize that same data, it returns nothing.

Please note that the balance field properties are set to:

Field Size: Double
Decimal Places: Auto
Require: No
Indexed: No

Any insight into this problem would be greatly appreciated, as I have never encountered it before.

 

[dhookom]

Minimally, you need to provide some SQL statements. In addition some sample data, expected results, and actual results would be helpful. How about all significant data types? If you are using any user defined functions, we need the code.

Duane
Hook'D on Access
MS Access MVP