QUERY

[Gambler]

When i query for a conditions. I put in MSW and get only MSW races, When I put in *C* I get all the claming races. My problem is Maiden Races. If I put in M,or MC or *MC* I get nothing. If I put on *M* I get Maiden and MSW races. What do I put in to just get Maiden races?
Thanks
ed

[Rick]

Download HX4.txt

http://www.homebased2.com/km/dnl/hx4.txt

[Rick]

What field in what table are you trying to query?

[Victor]

Hi Gambler,

08 "nCLA" Class Type 1=Alw/Stk; 2=Clm; 3=Msw; 4=Mcl

If you type in a '4' in the criteria box of the nCLA field, you should get only Mcl races.

[Gambler]

The field is nCLA. I had Ken change it to text. So it is tCLA.When I look at it in my query under tCLA it is listed as M04. Yet when I put M in there, nothing comes up. I just figured it out but dont know why it works this way. If i put in *M0* I get all the MC under 10,000. Then if i put in *M1* i get those above 10,000. I can live with that.
Thanks for helping
ed

[Victor]

ed,

You might also try using the nPURS field for defining the purse level you're interested in:
"nPURS" Purse x 1000 eg: 38 = purse value = $38,000
and if you were also interested in defining the claiming price (in a Maiden Claiming race), you could use the nCLM field:
"nCLM" Claiming Price x 1000 eg: 20 = $20000 claimer
0 = not a claiming race

So if for example you want Maiden Claiming with purse under $10,000 and claiming price under $5000, you could write:
nCLA=4
nPURS<10
nCLM<5

[Rick]

That is the way HTR4MSA had it. Great to look at but not for doing select queries in Access.

You need to make a list of all the possible responses and then figure out what each one means.

Some are easy like MSW and the M05. Then you have the OCL, CLF, Gr1, NW1 and even the state bred NW1s.

It is much easier to use the fields in HX4 to get what you want.

To get all the MSW you have to use like "ms*"

For the MCL you can use like "m[!s]*"

The !s is for NOT s

Checkout an Access book for working with wildcards.

When you know what is in that field then you can come up with criteria to select or not select info.

[Gambler]

Thanks for helping.
You gave me a lot of great ideas.