Age of madness
New Member
- Joined
- Oct 18, 2006
- Messages
- 9
Hi
Onto the next problem
I am currently trying to add in a lookup type query where if the figure is between 2 values then a second column will autofill with the corrospding figure.
so
Pts - Column1 - Column2
200 to 300 - 10 - 20
301 to 400 - 15 - 25
401 to 500 etc
What would be the best way to go about this?
cheers
Onto the next problem
I am currently trying to add in a lookup type query where if the figure is between 2 values then a second column will autofill with the corrospding figure.
so
Pts - Column1 - Column2
200 to 300 - 10 - 20
301 to 400 - 15 - 25
401 to 500 etc
What would be the best way to go about this?
cheers