Numerical order

[Guest]

I think this is going to be a tough one.
I made a small database for the local Gun Club for their events.
The reports show each competitors scores and naturally, the highest score
wins. However, the old problem rears it's head. Is there a way I can make the
report show that the score of 100 is higher than 99?

 

[Guest]

What you need to ensure is that the format is set to Number, and not Text.
That should work.

Cheers

 

[Allen Browne]

In table design, use a field of type Number, not Text.

If you still have problems when you calculate totals, typecast the fields in
your query, and set the Format proeprty of the text box on your report.
Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

 

[Guest]

Thanks to both of you. Once again, a simple solution.
Both of you are a wealth of knowledge.