Count of two fields across two tables query

[maym14]

Hi, I am a complete newbie when it comes to Access. I have, what should be, a fairly simple problem to solve.

I am trying to write a query that will count the different number of race types across different track conditions for my horse racing database.

So I have:
Table 1 (field is called Race_Type)


Table 2 (field is called Track_Condition)

So I am looking for how many different occurrences of each race type there is across the different track conditions.

I have tried to write an expression but I do not get the correct results.

Should this be done through SQL? If so, how could I do this?

Thank you for your assistance.

[June7]

Really need more info. How are these tables related? Is there a Race_Type field in Table 2? Show example records.

[maym14]

No, there isn't a Race_Type field in table 2. I am not sure how to show you an example as my DB is too big?

[June7]

Can use the Advanced edit window to build a table in your post. Can even copy/paste rows from Access table or query object.

So how are these tables related?

What do you mean by 'write an expression' - expression where?

[maym14]

I have managed to re-create a small example in the attached.

In the query, 'qrytest', you will see that I have managed to show the race type and the track condition. You can see in this very small sample size, that I have 4 "Open" type races (record 4-7). These are the only common race_types in the sample data.

So I should be able to have another column that shows that race_type "Open" in track_condition of "Good" has 4 races in total (and the rest have 1 each).

But I cannot work out how to do this?

[aytee111]

Create a new query from qrytest, make it a totals query (click on the E icon at the top), group by race type and track condition, then select any other field and use Count.