Access 2007 Error 3079
Contents |
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and error 3079 ffxiv reference Dev centers Retired content Samples We’re sorry. The content you requested
Ff14 Error 3079
has been removed. You’ll be auto redirected in 1 second. MSDN Library MSDN Library MSDN Library MSDN Library
The Specified Field Could Refer To More Than One Table Access
Design Tools Development Tools and Languages Mobile and Embedded Development .NET Development Office development Online Services Open Specifications patterns & practices Servers and Enterprise Development Speech Technologies Web Development Windows Desktop App Development TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. The specified field Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services https://msdn.microsoft.com/en-us/library/bb209753(v=office.12).aspx Groups Website Testing Store Headlines Experts Exchange > Questions > Access SQL Query Error 3079: Specified field could refer to more than one table listed Want to Advertise Here? Solved Access SQL Query Error 3079: Specified field could refer to more than one https://www.experts-exchange.com/questions/25024560/Access-SQL-Query-Error-3079-Specified-field-could-refer-to-more-than-one-table-listed.html table listed Posted on 2010-01-06 MS Access Query Syntax 4 Verified Solutions 19 Comments 1,625 Views Last Modified: 2013-11-29 So I think I'm using fully qualified field names (by including the table names and brackets and all) everywhere, but it's still giving me this message. What's going on? Normally fully-qualified names fix this. What am I shooting for? I'm trying to make a query to update the data in ModelTaskDataLocal from a more recent table qryModelDataPPQ according to the instructions at: http://office.microsoft.com/en-us/access/ha100765271033.aspx UPDATE [ModelTaskDataLocal] INNER JOIN [qryModelDataPPQ] ON ([ModelTaskDataLocal].[PM_FREQUENCY] = [qryModelDataPPQ].[PM_FREQUENCY_DAYS]) AND ([ModelTaskDataLocal].[TIME_STAMP] = [qryModelDataPPQ].[TIME_STAMP]) AND ([ModelTaskDataLocal].[ModelData_MODEL_WO_NBR] = [qryModelDataPPQ].[MODEL_WO_NUMBER]) AND ([ModelTaskDataLocal].[PM_LATEST_DATE] = [qryModelDataPPQ].[PM_LATEST_DATE]) AND ([ModelTaskDataLocal].[PM_EARLY_DATE] = [qryModelDataPPQ].[PM_EARLY_DATE]) AND ([ModelTaskDataLocal].[PM_DUE_DATE] = [qryModelDataPPQ].[PM_DUE_DATE]) AND ([ModelTaskDataLocal].[PM_CAT_CD] = [qryModelDataPPQ].[PM_CAT_CD]) AND ([Mo Custom Search UtterAccess Forums>Microsoft® Access>Access Errors + Error Handling Runtime Error 3079 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code http://www.utteraccess.com/forum/runtime-error-3079-t1413074.html Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User http://www.office-forums.com/threads/sql-runtime-error-3079.597875/ Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access error 3079 Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and access 2007 error VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options jin880View Member Profile May 9 2007, 01:16 AM Post#1Posts: 272Joined: 11-July 05Anyone know why I am getting this error message after I put in the code pictured. The code is meant to make the names from a list on a subform "clickable".Attached File(s) Error.jpg ( 50.25K )Number of downloads: 8 mishejView Member Profile May 9 2007, 01:36 AM Post#2Retired ModeratorPosts: 11,289Joined: 25-September 02From: Milwaukee, WIOne or more of the tables in your query have this field. Since you have not specified w When I use the critieria [Last Name] in my WHERE clause I receive the runtime error 3079 "The specified field '[Last Name]' could refer to more than one table listed in the FROM clause of your SQL statement. I will not post the whole SQL statement here unless it is needed, but I have looked at it, and there is NOT a [Last Name] in more than one table. The only table with a field [Last Name] is tblEmployeeData. So I modifed my WHERE criteria to specifiy the specific table and specific field (tblEmployeeData.[Last Name]) However, this does not seem to make a difference. I still get the runtime error. Does anyone have thoughts on why I get this error even when there appears to be no other table with the specific field. Thanks! Justin83716, Apr 26, 2007 #1 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Similar Threads Access 97 front end to SQL 2000 back end - SQL permissions Neil Moss, Jun 3, 2004, in forum: Access Forms Coding Replies: 0 Views: 162 Neil Moss Jun 3, 2004 Error 3079: specified field cold refer to more than one table... JohnLute, Nov 17, 2004, in forum: Access Forms Coding Replies: 2 Views: 206 JohnLute Nov 17, 2004 Access generated sql vs. VB sql Stephanie, Jan 28, 2005, in forum: Access Forms Coding Replies: 9 Views: 66 Stephanie Jan 28, 2005 Access and SQL, upating an sql table? please help! RON, Mar 24, 2006, in forum: Access Forms Coding Replies: 2 Views: 158 TC Mar 24, 2006 Runtime error 2467: Application-defined or object-defined error. Nick Terry, Jul 12, 2006, in forum: Access Forms Coding Replies: 2 Views: 272 Klatuu Jul 12, 2006 Error handler for runtime error 92 "invalid use of null" not working , Aug 30, 2007, in forum: Access Forms Coding Replies: 3 Views: 99 Aug 31, 2007 sql update from runtime Jamal, May 12, 2009, in forum: Access Forms Coding Replies: 1 Views: 50 Albert D. Kallal May 12, 2009 Set Form height at Runtim