Count Minimum and Maximum values in a report

[mshakeelattari]

I have a query in MS Access that gets data from other queries. It generates a field that contains numeric data and, if no number, a string: "Abs". When designing report based on this query, the Min() function gives the minimum number of the field whereas Max() function returns the string "Abs". But I want the Min and Max values from only the numbers. Any help will be appreciated.
Thanks

[jforbes]

It sounds like the column you are attempting to get the Max() out of isn't numeric. You'll want to set it to numeric, if you can, or if this query starts taking a long time to return results. So, if you want to leave the Table the way it is, you can try:

Max(Val([YourFieldName]))

This will cause a conversion to a numeric value on the field. This will convert text to a zero and if the field is alphanumeric, it will grab the number, if it is before any text, and use it. ex:

"2" -> 2
"2f2ff2f22f" -> 2
"ff2ff2f2ff2" -> 0

[twinnyfo]

You could also add criteria to your query:

WHERE [FieldName] <> "Abs"

[mshakeelattari]

jforbes and twinnyfo, Thak You