Hi La Mer,

Have you tried using related access tables?

I have all the values and corresponding decimal equivalents in one table, then import my excel files into a related table.

The query then substitutes the old value to the decimal odds.

__________________
RaceCensus - powerful system testing software.
Now with over 426,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/10/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg