 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / March 2007ambiguous name. in query expression
hello, i wrote expression in query and i work fine. when i import this query to another (but the same) application it gives me the error statment above. what can be the reason ?  Signatureתודה רבה are u using the same field name twice in your query? > hello, > [quoted text clipped - 5 lines] > > what can be the reason ? On Tue, 27 Mar 2007 16:04:09 -0700, ???? ????? <yarivr@tasmc.health.gov.il> wrote: >hello, > [quoted text clipped - 5 lines] > >what can be the reason ? If you use the same fieldname twice, you MUST explicitly name the table: put [tablename].[fieldname] wherever you refer to the field, so Access can tell which table's field you mean. It's also a good idea to define an Alias name: in the query grid put NewName: [tablename].[fieldname] where NewName is some name not used elsewhere in the query. John W. Vinson [MVP] thank you john !!! Signatureתודה רבה > On Tue, 27 Mar 2007 16:04:09 -0700, ???? ????? <yarivr@tasmc.health.gov.il> > wrote: [quoted text clipped - 20 lines] > > John W. Vinson [MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.