P
Pele
In trying to create a query (name = QueryOne), I joined
two tables with fields that were both TEXT fields (field
size=50. The field were named Product ID. I then added
another TEXT field called Supplier ID to the query. The
Supplier ID field had entries like 01, 02,10,20 etc.
I then tried to combine QueryOne with a table called
Supplier by using the Supplier ID from QueryOne with
Supplier ID (TEXT field) from the table called Supplier.
Unfortunately, the Supplier ID from the Supplier Table
came in as a blank.
Can somebody tell me what I need to do to ensure that when
I use a text field from a table that it is left as a text
field in the query.
Pele
two tables with fields that were both TEXT fields (field
size=50. The field were named Product ID. I then added
another TEXT field called Supplier ID to the query. The
Supplier ID field had entries like 01, 02,10,20 etc.
I then tried to combine QueryOne with a table called
Supplier by using the Supplier ID from QueryOne with
Supplier ID (TEXT field) from the table called Supplier.
Unfortunately, the Supplier ID from the Supplier Table
came in as a blank.
Can somebody tell me what I need to do to ensure that when
I use a text field from a table that it is left as a text
field in the query.
Pele