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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
No Current Record
When I run a query I get "No current record" error message. Thpis is a very
old query and I have never had a problem with it. Thanks in advance eric query INSERT INTO JobDevMain ( SocialSecurityNumber, FirstName, LastName, RetentionStartDate, JobDeveloper, FundingSource, ClientStatus, CaseManagerOrESC, LastOfContractorName, Job1Employer, Job1HourlyWage, Job1BenefitsAvailable, Job2Employer, Job2HourlyWage, Job2BenefitsAvailable, Job3Employer, Job3HourlyWage, Job3BenefitsAvailable, Job1Startdate, Job2Startdate, Job3Startdate, Job1Enddate, Job2Enddate, Job3Enddate, TermDate ) SELECT [Client Info].SocialSecurityNumber, [Client Info].FirstName, [Client Info].LastName, [Client Internal Activities].RetentionStartDate, [Client Internal Activities].JobDeveloper, [Client Internal Activities].FundingSource, [Client Internal Activities].ClientStatus, [Client Internal Activities].CaseManagerOrESC, Contracts.ContractorName, [Client Jobs and Outcomes].Job1Employer, [Client Jobs and Outcomes].Job1HourlyWage, [Client Jobs and Outcomes].Job1BenefitsAvailable, [Client Jobs and Outcomes].Job2Employer, [Client Jobs and Outcomes].Job2HourlyWage, [Client Jobs and Outcomes].Job2BenefitsAvailable, [Client Jobs and Outcomes].Job3Employer, [Client Jobs and Outcomes].Job3HourlyWage, [Client Jobs and Outcomes].Job3BenefitsAvailable, [Client Jobs and Outcomes].Job1StartDate, [Client Jobs and Outcomes].Job2StartDate, [Client Jobs and Outcomes].Job3StartDate, [Client Jobs and Outcomes].Job1EndDate, [Client Jobs and Outcomes].Job2EndDate, [Client Jobs and Outcomes].Job3EndDate, [Client Internal Activities].[Pittsburgh Partbership Termination Date] FROM (([Client Info] LEFT JOIN [Client Jobs and Outcomes] ON [Client Info].SocialSecurityNumber = [Client Jobs and Outcomes].JobSSN) LEFT JOIN (Contracts RIGHT JOIN [Client Contracted Activities new] ON Contracts.ProjectID = [Client Contracted Activities new].ProjectID) ON [Client Info].SocialSecurityNumber = [Client Contracted Activities new].SocialSecurityNumber) LEFT JOIN [Client Internal Activities] ON [Client Info].SocialSecurityNumber = [Client Internal Activities].SocialSecurityNumber WHERE (((Contracts.ProjectID)=284 Or (Contracts.ProjectID)=261 Or (Contracts.ProjectID)=304 Or (Contracts.ProjectID)=316 Or (Contracts.ProjectID)=394 Or (Contracts.ProjectID)=411 Or (Contracts.ProjectID)=412 Or (Contracts.ProjectID)=181 Or (Contracts.ProjectID)=313 Or (Contracts.ProjectID)=275 Or (Contracts.ProjectID)=435 Or (Contracts.ProjectID)=436 Or (Contracts.ProjectID)=63 Or (Contracts.ProjectID)=419 Or (Contracts.ProjectID)=302 Or (Contracts.ProjectID)=435 Or (Contracts.ProjectID)=520 Or (Contracts.ProjectID)=530 Or (Contracts.ProjectID)=545)) GROUP BY [Client Info].SocialSecurityNumber, [Client Info].FirstName, [Client Info].LastName, [Client Internal Activities].RetentionStartDate, [Client Internal Activities].JobDeveloper, [Client Internal Activities].FundingSource, [Client Internal Activities].ClientStatus, [Client Internal Activities].CaseManagerOrESC, Contracts.ContractorName, [Client Jobs and Outcomes].Job1Employer, [Client Jobs and Outcomes].Job1HourlyWage, [Client Jobs and Outcomes].Job1BenefitsAvailable, [Client Jobs and Outcomes].Job2Employer, [Client Jobs and Outcomes].Job2HourlyWage, [Client Jobs and Outcomes].Job2BenefitsAvailable, [Client Jobs and Outcomes].Job3Employer, [Client Jobs and Outcomes].Job3HourlyWage, [Client Jobs and Outcomes].Job3BenefitsAvailable, [Client Jobs and Outcomes].Job1StartDate, [Client Jobs and Outcomes].Job2StartDate, [Client Jobs and Outcomes].Job3StartDate, [Client Jobs and Outcomes].Job1EndDate, [Client Jobs and Outcomes].Job2EndDate, [Client Jobs and Outcomes].Job3EndDate, [Client Internal Activities].[Pittsburgh Partbership Termination Date] HAVING ((([Client Internal Activities].RetentionStartDate)=[Forms]![Main]![Rdate])); |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Restrict Report To Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
Restrict Report to Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
ow to get Current Record from the subform with the datasheet | Tom | New Users | 0 | June 17th, 2004 09:07 PM |
Printing report for current record | Linda | Setting Up & Running Reports | 1 | May 26th, 2004 05:46 PM |