Query renames field as Field0

[Karyn]

I have a query which joins data from two tables. I added a field to one of the tables and had the query include it in its selection. It works, except the field appears named 'Field0' instead of its proper name. What causes this?

Oh, ignore me, it's too early in the morning. Of course it's because the field is already there.

[ranman256]

Name any field by putting a label before the function with a colon between....
MyField: [rate]*[hrs]