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
|
|||
|
|||
Report using Fields with the same name from different tables
Hello all -
I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. What is the best way to proceed? Thanks - Lee -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
#2
|
|||
|
|||
Report using Fields with the same name from different tables
TheLee via AccessMonster.com wrote:
I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. The parameter prompts are because you also need to change all the places where the changed names are used. After going through that exercise, you will have learned to put more planning into creating names. If worst comes to worst, Access will accept table.field syntax in most places. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Report using Fields with the same name from different tables
lol - Yea, I thought that was what I would have to do.
Thanks - Marshall Barton wrote: I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. The parameter prompts are because you also need to change all the places where the changed names are used. After going through that exercise, you will have learned to put more planning into creating names. If worst comes to worst, Access will accept table.field syntax in most places. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201005/1 |
Thread Tools | |
Display Modes | |
|
|