Please help

  • Thread starter Thread starter TBird
  • Start date Start date
T

TBird

I have a long primary key, and it's divided into several sub-units (like
a social security number). However, only the last 4 digits are unique,
how can I limit my search in a query to just the last 4?
 
best way to solve this...

in the query definition, create a calculated field defined as the right 4 digits of the primary key...
NewField: right([primary_key],4)
and then set your constraint on this new calculated field instead of the original primary key field.
 
I have a long primary key, and it's divided into several sub-units (like
a social security number). However, only the last 4 digits are unique,
how can I limit my search in a query to just the last 4?
Click to expand...

Divide it into several fields, and make the 4-digit final one the
Primary Key. If it's unique, it'll be a better key!

Concatenate the separate fields for display purposes, in a Query or in
the control source of a form or report field.
 
Back
Top