General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Selecting records by field content
Environment versions
Network:
Windows 2000 Server
I have a table that collects reason codes for Drawing changes. The reason codes are three numbers, one each for a respective category. Example: Category I value is 1, Category I value is 2, Category I value is 3 the reason code would be 123. I am trying to come up with an efficient way to report the code combinations, displaying the Category options that were originally offered. Suppose I want all the records that have a 1 in the first position, a 2 inthe second position and anything in the third position. I know there must be an easy way to do this, better than my Do Case scheme.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only