A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report using Fields with the same name from different tables



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 04:42 PM posted to microsoft.public.access.reports
TheLee via AccessMonster.com
external usenet poster
 
Posts: 7
Default 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  
Old May 19th, 2010, 07:06 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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  
Old May 19th, 2010, 07:14 PM posted to microsoft.public.access.reports
TheLee via AccessMonster.com
external usenet poster
 
Posts: 7
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.