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 :)
JC_LivesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
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
0
Richard DanekeTrainerCommented:
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
0
Rey Obrero (Capricorn1)Commented:
DoDahD,
you are just keep repeating my post, since this morning
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

JC_LivesAuthor Commented:
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"...
0
Rey Obrero (Capricorn1)Commented:
post the sql of the queries, start from the frst query, then the second etc

or upload your db
0
rg20Commented:
try a nested query might manually type it but something like
select desiredNameField as 'Desired Name' from table1 where desiredNameFieldID = (Select desiredFieldID from table2 where desiredID = userinputedDeiseredID)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JC_LivesAuthor Commented:
thank you
0
rg20Commented:
Not a problem, glad it worked for you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.