Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with field type

Status
Not open for further replies.

sfc85

Programmer
Mar 16, 2003
8
KW
hi again

i intend to link two "numeric" fields from one query and one "LINKED" table originally from foxpro

the data type of the query field is numeric but the table field is text and i cant change it because the field in this linked table is set as a text field in foxpro.

Changing the text field to a numeric one in foxpro is causing problems to the original program written in foxpro!

when i try the query i get "type mismatch in expression"

Is there a solution to change the field type of the linkled table in access from a text to numeric type without affecting the original foxpro dbf file?

Any advice?

thanks

rami
 
You could try
WHERE AccessTable.NumericField = Val(FoxProTable.TextField)

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
thanks CajunCenturion

problem solved again

rami
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top