Please can someone help. I want to query some data for 6 years 
I want to do one one year at a time then add the answer to stats 5. can someone
help me with the code please. Thanks Tony



method run(var eventInfo Event)

var

	 tab table
  tc tCursor


	qb Query


	endVar
 

			  qb=Query
ANSWER: C:\Program Files\Corel\Shared\Private\1.DB

XrunJM.DB | Type          | RaceNo       | 
			 | Check UK Flat | Check _join1 | 

XrunJM.DB | Date                                   | Type of Race | 
			 | Check _join2,>=01/03/2019,<=31/12/2019 | Check        | 

XrunJM.DB | Horse Name | Sex    | Age    | Weight | Blinkers | Position |

			 | Check      | Check  | Check  | Check  | Check    | Check    | 

XrunJM.DB | Distance Beaten | BHB Rating | RFM Rating | Speed  | sp     |

			 | Check           | Check      | Check      | Check  | Check  | 

XrunJM.DB | Trainer | Jockey | Allow  | FIELD028      | 
			 | Check   | Check  | Check  | Check as Draw | 

xraceJM.DB | Raceform Number | Date   | Pub Time | Condition  | Track   
    | 
			  | _join1          | _join2 | Check    | Check Hcap | Check ..GB.. |


xraceJM.DB | yds    | Value 1st | Type of Jockey | Type of RaceB | 
			  | Check  | Check     | Check          | Check         | 

xraceJM.DB | Age Condition | RAN    | Class  | 
			  | Check         | Check  | Check  | 

EndQuery



  qb.executeQBE()

	tab.attach("1")
tab.add("Stats5",True,False) 
			  













	endMethod