distance range crosstable

[Guest]

doing a greyhound race database and having trouble with say todays distance
in my crosstable i would like to extract all runs the dog has had within a
10% range of todays distance. eg. if todays race is 500m i want to extract
all runs in my select query that are within 450m and 550m and count the sum.
dont know how todo a percentage range query.any help???

 

[Duane Hookom]

Do you have a table structure you would like to share with us? How about
some sample records? What would you expect to see for row and column
headings? How about the value?

 

[Guest]

looks like this Duane...

Crosstable from dogs history-

Dogname 450m 516m 525m 549m 570m
Brett Lee 1 1 2 3 2

then i would like to do a select query that calcs the sum(number of runs)
when todays distance which is 500m and every run within 10% of that.so in
this case its total runs at 'approx' 500m is 7.
i need to use a percentage as todaysdistance is a variable.
Mark

 

[Duane Hookom]

Create this as a column in the crosstab and not after the crosstab. Or, if
all you want is the dog name and value then you don't need a crosstab.