I have a field in a query that I would like to display differently than what is stored in the table. The field is call apt# and the output looks like this 0000000011409468
Results 1 to 2 of 2
-
3 Star Lounger
- Join Date
- Jan 2001
- Posts
- 294
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2005-06-02 12:57Displaying a field in a query (Access 2003)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2005-06-02 13:04Re: Displaying a field in a query (Access 2003)
Create a calculated column in the query
AptDisplay: Left([apt#], Len([apt#])-1)
AptDisplay will be the name of the column in the query. You can change this.
