REPORT

[Gambler]

I made a report. I sorted by track, Race and program number. At least that was my intentions. I do sort by track and race but when It comes to program number I get the following.
1
10
2
3
4
5
Is there a way I can move the 10 to the end without having to rewrite the program?
Thanks
ed

[Rick]

The only way I know of doing it is to create a field to sort on.

Since the Program # field is a text field you get the sort that way.

You could sort on the post position field and it would be right most of the time.

What I would try is creating a table for the sort field. The table would only have two fields, the first field being all possible program numbers and the second field bing your sort code.

Your sort code could be text or numerical. I would use either one starting with AA or a numerical field.

You could then include both tables in your query and create a relationship based on the Program #.

I havn't tried this but it should work.

Now maybe someone that has done their own can tell you how they did it.

[AwolAtHTR]

hi,

Rick is right about the text sort but here is solution I use

add Field tPGM a second time, one for the report and one for the sort

for the Sort tPGM, edit to read sortPGM: val(tPGM)

the name sortPGM can be anything you want but it must have COLON after the name.

the VAL() function will evaluate a 1A as ONE, coupled horse numbers will not cause
the VAL() function to fail but will be sorted as one or whatever the coupled bet number
is as a numeric value. Sorry, no trick to get 1A after 1 or 2B after 2.

duane/AWOL

[MikeDee]

You can also sort on nPPO this is a numeric field. Most fo the time the nPPO sort is the same as the prog no sort, except the coupled entries. It will get the 10 and 11's in the right order though.