asked on

Access 2007 Query builder: Wrong name displayed

Hi,

I'm trying to display a different name than the field name. I see that you can say "desired name": field name in the top row of the query builder, but for some reason it's still not displaying the name as specified. It's showing "identifier", which is not even the field name. Any thoughts???

Thanks :)

Rey Obrero (Capricorn1)

assuming the actual name of the field from the table is MyField and you want to cahnge the name to display YourField in the query builder

Field YourField:MyField
Table

criteria

Richard Daneke

In QueryBuilder, a new field name preceeds the colon, as you indicate. No quotes are needed, hence:
Desired Name : validFieldName creates a new column with the heading Desired Name and the data as validFieldName

Rey Obrero (Capricorn1)

DoDahD,
you are just keep repeating my post, since this morning

JC_Lives

ASKER

Yea, I knew I could do that... but it's still displaying something other than the actual field name. The field comes through a sequence of queries... and the first query in the chain calls it "identifier". Somehow, even though the most recent query that my new query pulls from calls it "myfield", It's displaying "identifier"...

Rey Obrero (Capricorn1)

post the sql of the queries, start from the frst query, then the second etc

or upload your db

ASKER CERTIFIED SOLUTION

rg20

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JC_Lives

ASKER

thank you

rg20

Not a problem, glad it worked for you