[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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 :)
0
JC_Lives
Asked:
JC_Lives
  • 3
  • 2
  • 2
  • +1
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
JC_LivesAuthor Commented:
thank you
0
 
rg20Commented:
Not a problem, glad it worked for you
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now