Deleting the last 2 digits from a number using a Query update

  • Thread starter Thread starter Guest
  • Start date Start date
If it is truly a number you can do this --
Int([YourField]/100)

If it is a text field then do this --
Left([YourField], Len([YourField])-2)
 
OK I will give it a shot. Thaks very much

KARL DEWEY said:
If it is truly a number you can do this --
Int([YourField]/100)

If it is a text field then do this --
Left([YourField], Len([YourField])-2)

--
KARL DEWEY
Build a little - Test a little


RickJ said:
Could someone please give me the syntac for this? Thanks.
Click to expand...
Click to expand...
 
Thanks it worked (I had to add a semicolon instead of a coma).

How can I now add XX at the end of the word?

RickJ said:
OK I will give it a shot. Thaks very much

KARL DEWEY said:
If it is truly a number you can do this --
Int([YourField]/100)

If it is a text field then do this --
Left([YourField], Len([YourField])-2)

--
KARL DEWEY
Build a little - Test a little


RickJ said:
Could someone please give me the syntac for this? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top