probably a simple mistake. Trying to take a text field containing numbers in a query for a combobox. The number is 9 characters and I wish to display only the last 4. Using help and the net I have found:
last4: Right([SSN], 4)
but it alwayds returns an error that "...omitted an operand or operator..invalid character or comma...quotation marks..."
using Acess 2000 in English on a computer with Win2K in German. It has brought problems before, but this should work, right?