Search results for query: *

I imported the Prospect_Applicant table inot the Campus6 DB here is the sql with the joins. I want to have Recruiter_Selected come back with all the recruiteres that have a -1 in the field designated as a Yes. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME...

Yes you are right with your question.

In your From Statement dbo.Institute.Prospect_Applicant INNER JOIN dbo.PEOPLE LEFT OUTER ON This ON is the area of incorrect syntax

When I try your sql in a new view I am getting an error Incorrect syntax near the keyword "ON

Here is the original query. I want recruiters that have them selected to appear in the results . The table Prospect_Applicant from Data Base Institute is there this info is. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME, dbo.PEOPLE.LAST_NAME...

Campus^ is the other db here is the code with what you sent abovae added, but am getting an error stating:Incorrect syntax near OUTER FROM OUTER JOIN dbo.Institute.Prospect_Applicant ON dbo.CAMPUS6.People ON...

I want to add the table from the other data base do I have to and make joins explained in the past post.

Join Data Base Institute, Table Prospect_Applicant, Field Recruiter_People_Code_ID to Table PEOPLE, Field PEOPLE_CODE_ID Join Data Base Institute, Table Prospect_Applicant, Field Applicant_People_ID to Table PEOPLE, Field PEOPLE_ID

I have the view listed below and want to add a table from another data base to it. The data base is Institute and the table is Prospect_Applicant. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME, dbo.PEOPLE.LAST_NAME, dbo.ACADEMIC.ACADEMIC_YEAR...

I have databases that I have created in Access 2003 that work fine, but in the last few days when I try to import a form and query into a new db it freezes up and works very slow. Can any one provide any insight as to what I can do to make it run alot faster like it should?

Has any one had a problem with Access 2003 locking up and not working or opening forms, queries, tables extremely slow. I created a new db and imported all the above into it and it still performs very slow!

I have the following code and need help in creating a left outer join with the People table using People_Code_ID as the join. Here is the dba db and table name. dbo.Institute.Prospect_Recruiter. SELECT DISTINCT dbo.PEOPLE.PEOPLE_ID, dbo.PEOPLE.FIRST_NAME...

How can I rem and add multiple subscribers in audix in order to clear the subscriber so a new person can add their own messages. If I export and import will this do what I want? When I select export do I have to put the extension(100) along with the number and follow the steps or is there...

What I want is that the Person's Id, name Max to Min Class Years like below. P000039178 Bob Jones 1951 HSG 1953 JCG 1955 SCG

It is Select_Recruiter

I understand the concept of Max and Min for a criteria, but is there a way to bring back records that are between them as well. There are people who may have attended one class year or two class years or three class years. Example: Name Bob Jones 1980 High School 1984 Junior College 1986 Senior...

I have a query that should list all the records with a yes for Recruiter_Selected yet they do not. The main problem I am having is that this query worked great before and now it does not work at all without any changes made to it. Here is the query; SELECT DISTINCT People_Information.*...

The query will not work either for this report. All the tables in the query work yet the query will not work. It worked fine the other day without myself making any changes.

What causes # ERROR to show up where the data is supposed to be in a report. I know if you key in the wrong information for criteria of a query or have the report using a different query than what it should it will cause this error but this is not the case with me getting the # Error.

I have taken out the code above and it works as it should. Now the problem I am having is that the report will list one record with just the office held field and all other fields blank. and then other records that have the same office held field.