Access question

[Evan]

Sorry, this is a probably a pretty basic question but...

What I'm trying to do is to pull out certain
races where I think the favorite is vulnerable based on certain factors and then run queries over that set of races. IHow would I do this? I can pull out the vulnerable favorites themselves but I want the whole race so I can query it further.

[Donnie]

Evan-
You need to set the criteria field under the nRAC field to just the specific races you want to see. In other words let's say I think the favorite is vulnerable in races 1 and 3, in the criteria box for the Track enter the track's initials and in the nRAC column enter "1 0r 3" (without the quotation marks) in the criteria field. This wil bring you at the said track just racehorses who are running in those specific races.

Holler if I have confused you!

[MikeDee]

If I am understanding your question what you want to do is to first id the races that have a vulnerable favorite. Then in a second query look at those races with all of the horses and htr data to make selections. This is a varation of Donnies method, so that you don't have to id lthe races first.

I would do this with a query built on a query. If this is what you mean try this.

Take the query with your races that have the vulnerable favorite. In the design mode "unclick every column that has your criteria in it except track and race. The criteria is still applied, but the factors will not show up in the output. When you run this query the only thing that will show is the track and race number for the races with the vulnerable favorites. Now save this query with some name.

Next make a new query in the design view. Put your main table in the design. Next click on queries tab and put the query you just built in the design as well.

Now link the table and query with track and race. This linking will give you only those races in your vulnerable favorite query but now you can put any data items in the design from your main HTR table and look at all the horses in the race and do what ever you want.

If this is not what you meant...........never mind
:confused:

[Bernie]

If you're setting this up to do backtesting, I think you'll also need to add date to the query with track and race in it.

[Evan]

Thanks for the help guys. Figured it out at about 2am last night....what Mike said was what I ended up doing.

[hurrikane]

Evan, I believe you have to add what Bernie said to what Mike said. Hopefully you did this.

by the way..did you get the package?

[Evan]

Yeah, I did. Once I found the inner join option I got through it.

No luck on the package yet. I think there might be some rogue mail carrier running his own horse queries at home :eek: