I'm an "intermediate user" of Access 2003. I want to link a newly created two-field table to an existing query via a common numeric field, but I can't get it to work. (The second field in the tbl is a text field.) I've tried all different join options in the query design view, but the results still won't display when I run the query. I'm linking via the numeric field and trying to get the text field to display in the datasheet view.
I may have a data field incompatibility problem, but I can't be sure. I know how to check the data type in the table, but I can't find a way to check the data type for the calculated data field in the the query. (I'm trying to connect a numeric calculated field in the query to a counterpart numeric field in the table.)
I tried looking thru the online Help but haven't found a solution yet.
Can anyone help? I would sure appreciate it.
Wally DingDing