track conditions - records

[stugots]

hoping someone may be able to save me a bit of time - I have a bit of a problem regarding the recording of venue track conditions over the last year or so - I record by Unitab venue codes (BR, CR etc) & also by track name.

If anyone with the relevant records would be able to provide a list of 'venue - track conditions' for the last 12 months it would be most appreciated.

[jazzy]

Sure, do you want every day or just Saturdays, Metro only or the lot?

Like this? (example for last monday)

(format can be anyway you want, it's a simple SQL query)

rcdate raceno track state going
========== ====== ================ ===== =====
2011-04-18 1 GRAFTON NSW H
2011-04-18 2 GRAFTON NSW H
2011-04-18 3 GRAFTON NSW H
2011-04-18 4 GRAFTON NSW H
2011-04-18 5 GRAFTON NSW H
2011-04-18 6 GRAFTON NSW H
2011-04-18 7 GRAFTON NSW H
2011-04-18 8 GRAFTON NSW H
2011-04-18 1 KILMORE Vic D
2011-04-18 2 KILMORE Vic D
2011-04-18 3 KILMORE Vic D
2011-04-18 4 KILMORE Vic D
2011-04-18 5 KILMORE Vic D
2011-04-18 6 KILMORE Vic D
2011-04-18 7 KILMORE Vic D
2011-04-18 8 KILMORE Vic D
2011-04-18 9 KILMORE Vic D
2011-04-18 1 NARROMINE NSW D
2011-04-18 2 NARROMINE NSW D
2011-04-18 3 NARROMINE NSW D
2011-04-18 4 NARROMINE NSW D
2011-04-18 5 NARROMINE NSW D
2011-04-18 6 NARROMINE NSW D
2011-04-18 7 NARROMINE NSW (NULL)

[stugots]

Hi Jazzy, I am after every day every meet for the last 12 months & that format would be great

many thanks

[jazzy]

Here 'tis

[stugots]

cheers jazzy