Error 3079 Access 2007

98 & ME Support Windows Servers Microsoft Office Support Internet Browsers and Email Internet Explorer & Edge Forum Mozilla / Firefox Browsers Other Browsers error 3079 ffxiv Email Alternative Computing Linux Support Mac Support Other Operating Systems Hardware Support ff14 error 3079 Overclocking Motherboards, Bios & CPU Hard Drive Support Removable Media Drives RAM & Power Supply Sound Cards

The Specified Field Could Refer To More Than One Table Access

Case Mod Driver Support Video Card Support Printer Support Laptop Support Building Other Hardware Support Networking Forum Networking Support Modems / Cable / DSL / Satellite Cabling & Network Cards Protocols & Routing File & Application Sharing Security & Firewalls The IT Pro Certification & Career Programming Gaming Forum PC Gaming Support Game Installation Support Console Gaming Support Online/Network Gaming Support Mods & Maps Gaming Discussion Design Forum Web Design & Dev Graphic Design/Multimedia Web Serving & Management Design Discussion & FAQ Website Design Counsel Smart Devices Apple iOS Android OS Blackberry/RIM OS Palm WebOS Windows Mobile Other Mobile Tech Support Articles Apple Certification Gaming General Hardware Internet Linux Networking Photography Security Software Tips & Tricks Windows Spyware 1st Steps Rules Tech Support Forum > The IT Pro > Programming HELP!!!!!! Access Error 3079 User Name Remember Me? Password Site Map Posting Help Register Rules Today's Posts Search Site Map Home Forum Rules Members List Contact Us Community Links Pictures & Albums Members List Search Forums Show Threads Show Posts Tag Search Advanced Search Search Site / Google View Posts New Posts Your Posts Go to Page... HELP!!!!!! Access Error 3079 This is a discussion on HELP!!!!!! Access Error 3079 within the Programming forums, part of the Tech Support Forum category. The specified field could refer to more than one table listed in the FROM clause of your SQL statement. Thread Tools Search this Thread 08-28-2009, 11:17 AM #1 Loope Registered Member Join Date: Jun 2009 Location:

Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 10-03-2011, 05:57 AM #1 Ladyoftheputers Newly Registered User Join Date: Sep 2011 Location: TooColdEast Posts: 6 Thanks: 1 Thanked 0 Times in 0 Posts Error 3079 Hello! New to the forum, but not programming nor http://www.techsupportforum.com/forums/f128/help-access-error-3079-a-408920.html Access. I'm still kinda "old" skewel in Access & programming, but trying to catch up! I hesitated to post as this will be rather long but, since I'm banging my head!!! Anyway, my prob... I've 'migrated' a db from A97 to 2007. After several months, I've FINALLY got it compressed, compiled & working (mostly) http://www.access-programmers.co.uk/forums/showthread.php?t=216351 in 2007! I said mostly because there are a few probs.. the main one which is really bugging me is this 3079 error... it says that my specified field could refer to more than one table listed in the FROM clause of my SQL. Okay, I could understand that under normal circumstances, but the thing is....this field is only in two tables in the entire db...and only one table that has that field is being referenced anywhere in any of the SQL statements. The error is coming when I have a popup that a user selects which date range they want to use to print the report. The VBA line is: DoCmd.OpenReport "MBookings", acViewPreview, "MBookingsQuery", "(([Status.StatusCode] = 'S') AND (([MBookingsQuery]![Jobs.ResolutionsDate]) >= [Forms]![frmReportDateRanges]![txtBeginDate]) AND (([MBookingsQuery]![Jobs.ResolutionDate]) <= [Forms]![frmReportDateRanges]![txtEndDate]))" The field is "Jobs.ResolutionsDate". The criteria query is: SELECT DISTINCTROW Status.StatusCode, Status.StatusName, Employees.LastName, Employees.FirstName, Jobs.ResolutionDate, PContracts.ContractNumber, Jobs.JobID, Jobs.LocationID, Jobs.JobName, Jobs.BaseBid AS OldBaseBid, IIf((IsNull([CalcTotal])),[OldBaseBid],[CalcTotal]) AS BaseBid, [RegUndecMat]+[RegUndecTax]+[RegUndecLabor]+[RegUndecTON]+[RegUndecSubcontracts]+[RegUndecGM] AS CalcTotal, Jobs.GrossMargin, Jobs.ManDays, Locations.LocationName, IIf([Base

Custom Search UtterAccess Forums>Microsoft® Access>Access Errors + Error http://www.utteraccess.com/forum/index.php?showtopic=1413074 Handling Runtime Error 3079 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access error 3079 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 Automation|-- Access Database Container|-- Tool bars, Menu bars error 3079 access + 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 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 Foru