Hi,
I want to make a query where I have 2 tables:
Table 1: Purchase Orders Customer A
Table 2: Sales Order Supplier B
In the query I link the PO number out of Table 1 with the customer ref field in Table 2.
I get an error message because the types of field don't seem to match. After some research I found that the field type in Table 1 for PO number is numeric and Customer ref in Table 2 is text.
Does anyone know a way to fix this problem??
I link into both tables with an ODBC link
I want to make a query where I have 2 tables:
Table 1: Purchase Orders Customer A
Table 2: Sales Order Supplier B
In the query I link the PO number out of Table 1 with the customer ref field in Table 2.
I get an error message because the types of field don't seem to match. After some research I found that the field type in Table 1 for PO number is numeric and Customer ref in Table 2 is text.
Does anyone know a way to fix this problem??
I link into both tables with an ODBC link
