RIGHT function question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table (Main_Data) containing a string field (PID) that has 9
characters, with a sample value being 450895624. I have created a new field
(PID-4) that I only want the last 4 characters to show in, so the new field
would have the value: 5624 in it.

I believe this is a RIGHT function question, but am not sure. I thing that
the function needs to something like: RIGHT (PID,4), but don't know where to
go from there.

Also, if I wanted to do this in a select query, if I put "PID-4:" in the
'Field' box, what then would I put following the colon?


TIA!

Phil
 
hi,

That would be...

SELECT tbl_name.column1, Right([PID],4) AS new_columnname
FROM tbl_name;

geebee
 
Don't use the minus sign in the field name: Access is going to assume you're
trying to do subtraction. Try renaming it PID_Last4, or something like that.
 
Hello,

I have a table (Main_Data) containing a string field (PID) that has 9
characters, with a sample value being 450895624. I have created a new field
(PID-4) that I only want the last 4 characters to show in, so the new field
would have the value: 5624 in it.

I believe this is a RIGHT function question, but am not sure. I thing that
the function needs to something like: RIGHT (PID,4), but don't know where to
go from there.
Click to expand...

You cannot, and should not, do this in a Table. The table should not
contain redundant data like this - just calculate it as needed.
Also, if I wanted to do this in a select query, if I put "PID-4:" in the
'Field' box, what then would I put following the colon?
Click to expand...

As suggested, DON'T use the - character in the fieldname. Try

Pid_4: Right([PID], 4)

in a vacant Field cell in a query. You can set the text of the form or
report Label for this field to PID-4 or whatever you wish; the users
should not be seeing the query datasheet in any case, so the fieldname
isn't going to be exposed anyway.

John W. Vinson[MVP]
 
Back
Top