You may be pulling the Smart Field value from the wrong node in query.  For example, you may be pulling the Smart Field value from Household Details/Smart Fields. 

If you are viewing the Smart Field on the individual constituent record, you should pull the Smart Field value in query from the Smart Fields folder in the left column (Browse for fields in). 
  1. In the left column Browse for fields in, click on the plus sign to expand the folder. 
  2. Then click on the name of your Smart Field. 
  3. In the middle column, click Value and move this to Results Fields to Display to see the value of the Smart Field.
  4. Go to the Preview Results tab to preview the values of the Smart Field.
  5. Go to the Set Save Options tab to name and save your query.
Smart fields in query