query expression

[Azidano]

I have a Microsoft Access query with 3 fields as follows

fldName:John Doe
fldPhone: 123-456-7890
fldAddress: 123 Sample Road

I would like to create a query that will create a fourth field
(fldPhoneExt) that would display only the last 4 digits of the field
fldPhone. For example: xxx-xx-7890.

How would I modify my query to calculate this expression?

 

[fredg]

I have a Microsoft Access query with 3 fields as follows

fldName:John Doe
fldPhone: 123-456-7890
fldAddress: 123 Sample Road

I would like to create a query that will create a fourth field
(fldPhoneExt) that would display only the last 4 digits of the field
fldPhone. For example: xxx-xx-7890.

How would I modify my query to calculate this expression?

Add a new column to the query qrid.
fldPhoneExt:Right([fldPhone],4)

 

[Guest]

Expr1: Right([yourtablename].[fieldphone],4)

Type this into a new field in the query design grid.
It is the Right function which returns the rightmost characters in a string.
You can return any number of characters, but in your case you need 4.


HTH!

I have a Microsoft Access query with 3 fields as follows

fldName:John Doe
fldPhone: 123-456-7890
fldAddress: 123 Sample Road

I would like to create a query that will create a fourth field
(fldPhoneExt) that would display only the last 4 digits of the field
fldPhone. For example: xxx-xx-7890.

How would I modify my query to calculate this expression?

Add a new column to the query qrid.
fldPhoneExt:Right([fldPhone],4)

 

[Azidano]

I added the new column to query grid. It did not work. Am I supposed to
select a particular type of query? Such as Append, Update query, etc?

I have a Microsoft Access query with 3 fields as follows

fldName:John Doe
fldPhone: 123-456-7890
fldAddress: 123 Sample Road

I would like to create a query that will create a fourth field
(fldPhoneExt) that would display only the last 4 digits of the field
fldPhone. For example: xxx-xx-7890.

How would I modify my query to calculate this expression?

Add a new column to the query qrid.
fldPhoneExt:Right([fldPhone],4)

 

[Guest]

No you shouldn't have to select a particular type of query. Check your
syntax again, also, with my example:

Expr1: Right([yourtablename].[fieldphone],4)


Are you typing the full statement including 'Expr1:' into the field line?

I added the new column to query grid. It did not work. Am I supposed to
select a particular type of query? Such as Append, Update query, etc?

I have a Microsoft Access query with 3 fields as follows

fldName:John Doe
fldPhone: 123-456-7890
fldAddress: 123 Sample Road

I would like to create a query that will create a fourth field
(fldPhoneExt) that would display only the last 4 digits of the field
fldPhone. For example: xxx-xx-7890.

How would I modify my query to calculate this expression?

Add a new column to the query qrid.
fldPhoneExt:Right([fldPhone],4)