I'm no access buff: But I need some help! I have a form that searches by company name that run off these queries:
SELECT Contacts.[Prospect ID], Contacts.County, Contacts.Company, Contacts.Salesperson, Contacts.[Type of Business], Contacts.Title, Contacts.[Last Name], Contacts.[First Name], Contacts.[Location Address], Contacts.City, Contacts.State, Contacts.Zip, Contacts.[Office Phone], Contacts.Ext, Contacts.Fax, Contacts.[Cell Phone], Contacts.[Email Address], Contacts.[PO Box], Contacts.Customer, Contacts.Website, Contacts.[Reffered By], Contacts.[Alternate Phone], Contacts.[Contact 2], Contacts.[Proposal Date], Contacts.[Materials and Labor], Contacts.[Yearly Savings], Contacts.[KW saved], Contacts.[KWH /year saved], Contacts.[# New Fixtures], Contacts.[Installed project cost], Contacts.[Actual Savings], Contacts.[Installed # of Fixtures], Contacts.[Start Date], Contacts.[Action Plan], Contacts.[Level of Sale], Contacts.Prospect, Contacts.[Physical Data], Contacts.[Proposal Amount], Contacts.[Contingencies Removed], Contacts.[Power Company], Contacts.[Installed Date], Contacts.Notes, Contracts.[Open Contract], Contracts.[Contract Execution Date]
FROM Contacts LEFT JOIN Contracts ON Contacts.[Prospect ID] = Contracts.[Prospect ID]
ORDER BY Contacts.Company;
THE SECOND ONE:
SELECT Contacts.[Prospect ID] AS [Contacts_Prospect ID], Contacts.County, Contacts.Company, Contacts.Salesperson, Contacts.[Type of Business], Contacts.Title, Contacts.[Last Name], Contacts.[First Name], Contacts.[Location Address], Contacts.City, Contacts.State, Contacts.Zip, Contacts.[Office Phone], Contacts.Ext, Contacts.Fax, Contacts.[Cell Phone], Contacts.[Email Address], Contacts.[PO Box], Contacts.Customer, Contacts.Website, Contacts.[Reffered By], Contacts.[Alternate Phone], Contacts.[Contact 2], Contacts.[Proposal Date], Contacts.[Materials and Labor], Contacts.[Yearly Savings], Contacts.[KW saved], Contacts.[KWH /year saved], Contacts.[# New Fixtures], Contacts.[Installed project cost], Contacts.[Actual Savings], Contacts.[Installed # of Fixtures], Contacts.[Start Date], Contacts.[Action Plan], Contacts.[Level of Sale], Contacts.Prospect, Contacts.[Physical Data], Contacts.[Proposal Amount], Contacts.[Contingencies Removed], Contacts.[Power Company], Contacts.[Installed Date], Contracts.[Prospect ID] AS [Contracts_Prospect ID], Contracts.[Open Contract], Contracts.[Power Co Rate Schedule], Contracts.[Project Name], Contracts.[Contract Amount], Contracts.[Contract Execution Date], Contracts.[Credit Required], Contracts.[Rebate Claim # (or Electric Meter #)], Contracts.[Preapproval App Sent Date], Contracts.[Preapproval App Sent Amount], Contracts.[Recieved Preapproval Date], Contracts.[Recieved Preapproval Amount], Contracts.[PreInstall Completed Date], Contracts.[Proper Contract w EPS Codes], Contracts.[PreInstall Inspection], Contracts.[Initial EPS Spreadsheet w Codes], Contracts.[Initial Power Co App Sent], Contracts.[Initial Power Co Lighting Form Sent], Contracts.[Power Co Preapproval Recieved], Contracts.[Credit Approved], Contracts.[Credit App Sent], Contracts.[Credit App Recieved], Contracts.[Entered in Peachtree], Contracts.[PostInstall Date Completed], Contracts.[Final EPS Spreadsheet w Codes], Contracts.[EPS PostInstall Inspection], Contracts.[Final Power Co App Sent], Contracts.[Final Power Co Lighting Form Sent], Contracts.[Final Power Co Approval Recieved], Contracts.[Final Draft Invoice Done], Contracts.[Installation Dates], Contracts.[Rebate Invoice Done], Contracts.[Rebate Final App Sent Date], Contracts.[Power Co Inspection Date], Contracts.[Final Requested Amount], Contracts.[Final Rebate Amount] AS [Contracts_Final Rebate Amount], Contracts.[Rebate Payable to], Contracts.[Rebate Paid], Contracts.[Rebate Recieved Date] AS [Contracts_Rebate Recieved Date], Contracts.[Contract Paid in Full], Contracts.Notes AS Contracts_Notes
FROM Contacts LEFT JOIN Contracts ON Contacts.[Prospect ID] = Contracts.[Prospect ID]
WHERE (((Contracts.[Open Contract])=Yes))
ORDER BY Contacts.Company;
Don't know how to fix it.