Aahh - the perenial confusion between numbers and text.

While you want the user to enter a number, you really need the value to be text when you use it to locate the record by the key. Fortunately, GridView allows you to turn numbers into text using the STRING(value,mask) function. You're also going to need to add the text "RC " to the beginning of the text, and you're going to need to add some zeros to make everything the right length.

First things first.

Ask for the receipt number:
Code:
QUERYNUMBER("Which receipt?",0)

Now, convert what they enter into text:
Code:
STRING(QUERYNUMBER("Which receipt?",0),"###")

Now, add 7 leading zeros to whatever they entered:
Code:
CONCATENATE("0000000",STRING(QUERYNUMBER("Which receipt?",0),"###"))

but we only need the rightmost 8 characters from the string:
Code:
RIGHT(CONCATENATE("0000000",STRING(QUERYNUMBER("Which receipt?",0),"###")),8)

but the we need to put the text "RC " at the front:
Code:
CONCATENATE("RC ",RIGHT(CONCATENATE("0000000",STRING(QUERYNUMBER("Which receipt?",0),"###")),8))

Now you have to put all that in the filter:
Code:
{Rcpt #} = CONCATENATE("RC ",RIGHT(CONCATENATE("0000000",STRING(QUERYNUMBER("Which receipt?",0),"###")),8))

Voila!

But wouldn't it be easier to have all the receipt lines in a grid and use the ctrl-f find to locate the row with the receipt you're looking for?
_________________________
Andrew Bates