Is there a way I can create a query field that will take the spaces out of a field.

I want to turn this "Fifty five" into "Fiftyfive"

Use the Replace function:

Replace("Fifty five", " ", "")

I'm assuming that your value is actually in a variable (let's call it MyString), in which case you'd use

Replace(MyString, " ", "")

Awsome...you the man!