Result of Same Query to a Foxpro Linked Table Vary everytime

[ahsan69]

Hi all,

My Access database is linked to a foxpro dbf file and recently, I am coming across a weired problem. when I run the following query, each time I get a different result:

select sum(iif(tcat='F',tprice,0)) from treat where
year(date) = 2003 and month(date) = 5

your help to this will be greatly appreciated.

Thanks

Ahsan
Burlington, ON