ODBC Call Failed Error

[ALKnapp]

Hi,
I have several database files and I'm using Microsoft Access to link them. My query runs and displays until I attempt to scroll down. When I page down, I get the following error:

ODBC--call failed
[Microsoft][ODBC Visual FoxPro Driver]Error: Column 7(h_lnamt)(#0)

When I remove the h_lnamt field from the query, it runs and displays fine. The h_lnamt field is very necessary to my query. Any ideas as to what is wrong? I am not extremely familiar with Access so I'm hoping for a solution that isn't too complex. I would appreciate any help on this one.
Thanks!

 

[genomon]

It is probably bad data the source table. I've seen this a lot with Access/SQL Server here. Data looks OK until you move down - this mostly happens with calculated fields.