If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 has a bug. It renames my field caption like number
I set my field caption in a query in Access 2003 like this:
2006/07:July 2006 Data (I want to change the field name from another table to be 2006/07) ,but it change the caption to be 2006/7 !!!! Where is my zero before 7? This makes other queries that will link to this query cannot find this field. I need a service pack to solve this soon ! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...access.queries |
#2
|
|||
|
|||
Access 2003 has a bug. It renames my field caption like number
Something else is happening behind the scenes here.
If you would like us to try to help you sort this out, switch your query to SQL View (View menu in query design), and paste the entire SQL statement here in a reply to this thread. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Kraiwit" wrote in message ... I set my field caption in a query in Access 2003 like this: 2006/07:July 2006 Data (I want to change the field name from another table to be 2006/07) ,but it change the caption to be 2006/7 !!!! Where is my zero before 7? This makes other queries that will link to this query cannot find this field. I need a service pack to solve this soon ! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...access.queries |
Thread Tools | |
Display Modes | |
|
|