Ok, I'm baffled...
I'm making a query in access 97 between 2 tables. There is a field in
both tables called "DWGNO".
OPENORD has a record with a DWGNO of "0000001234 5"
DIEDATA has a record with a DWGNO of "12345"
I'm not doing this with VBA right now. I'm doing it through the query
gui.
My query:
Both tables are in the upper section with no links between them.
I have selected 4 fields. Only 3 are told to display results.
The field that is not showing results is where the criteria is entered.
The field is called DieData.DWGNO and the criteria is Like "*" &
[openord]![dwgno]
This shows no query results.
Please help me
I'm making a query in access 97 between 2 tables. There is a field in
both tables called "DWGNO".
OPENORD has a record with a DWGNO of "0000001234 5"
DIEDATA has a record with a DWGNO of "12345"
I'm not doing this with VBA right now. I'm doing it through the query
gui.
My query:
Both tables are in the upper section with no links between them.
I have selected 4 fields. Only 3 are told to display results.
The field that is not showing results is where the criteria is entered.
The field is called DieData.DWGNO and the criteria is Like "*" &
[openord]![dwgno]
This shows no query results.
Please help me
Comment