Query-Putting a label in front of real field name question (1 Viewer)

[Lilly420]

Hello,

I have a query in which some of the field names were assigned a while back and don't make a lot of sense to the person who gets the report so I give them new labels in the query...for example:

I pull in the field AE_resp_req and in front of that I type in RM Response: AE_resp_req and when I run the query, the name for the field is RM Response and it works great. I have another field called Category_Rating that I pull into this query and I did the same thing: Exam Rating: Category_Rating (field name) but when I run the query it still says Category_Rating and I get no errors or messages...this is the only field that does this--would anyone know why that might be?

Thank you for any help you can provide.

Lilly

 

[SmallTomato]

See if this helps you:
http://www.access-programmers.co.uk/forums/showthread.php?t=193708

 

[Lilly420]

Thank you so much, I had no idea about the Caption in the table property...I removed it and it works like a charm, thank you so much and sorry for not searching the forum first, I totally forgot to do that. Thank you again~

Lilly