Suzemt
Last Activity: Oct 7 '11, 07:19 PM
Joined: Oct 6 '11
Location:
-
By passing on to less adept users I was referring to the data base I have, not my query!!!! -
Sorry! no rudeness intended. I was looking for the more simple approach of just a select query without SQL. I may need to pass this on to less adept Access users. All advice is most gratefully accepted.Leave a comment:
-
OK. I have two tables. In table 1 the ID field contains a 7 digit number. In table 2 the ID field contains the same 7 digit number with /1 added. These fields are the primary key fields. JAGsters suggestion works great if I use another field as the primary key.Leave a comment:
-
I am looking for, if the 7 characters in table one, match the first 7 characters in table 2 (table 2 having more characters)then consider that a match.Leave a comment:
-
I am using Access. I want to retrieve records that match the numbers as shown above. The field is the primary key.Leave a comment:
-
How Do I Link Two Tables with Only a Partial Match
one table shows 123456 in ID the other table shows 123456/1
I want to return records where these two fields match but I don't want to specify the actual number, just where these fields match, even if it is partially. Help !
No activity results to display
Leave a comment: