Access 2003 Query - field name change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a relational query that draws from 3 tables -

I find that 2 of these tables has a field named [Phone] and I need both of
these 2 different phone fields in the final report the query generates.

How do I get the name of the 2nd Phone field in the query form to show up as
a different name - Like Orderphone etc. ?

I've done this before but can't remember how.

Thanks
 
FrankSpokane said:
How do I get the name of the 2nd Phone field in the query form to show up as
a different name - Like Orderphone etc. ?
Click to expand...

edit it and put in the caption you want then a colon

Phone_one:table_name.phone

you can also right click and edit the caption on the properties sheet
 
Back
Top