ST Alpha - "Other stupid Access question: Is there a way to link on a wildcard from table to table?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

Other stupid Access question: Is there a way to link on a wildcard from table to table?

Posted by Will Hunting (aka JoeMetz) Jul 22 '10, 07:24

the people here have data in the following format

1A503 with a Qty of 3.

our database has each of the 3 broken out like this:

1A503-001
1A503-002
1A503-003

I want to link the tables where the 1A503 links to the 1A503-00(1-3).

Responses:

WHERE [table].[key] = LEFT([table].[KEY], 8) -- nm - JaxSean Jul 22, 07:28 2
- Thanks! I will fiddle around with this and make it rain in your honor. -- nm - Will Hunting Jul 22, 07:40 1
  - *dances* -- nm - JaxSean Jul 22, 07:55

Post a message top

Other stupid Access question: Is there a way to link on a wildcard from table to table?

Replies are disabled on threads older than 7 days.