query results show several "copies" of same record

[Guest]

I have a query including fields job #, job name, DBuser, date entered. It
works fine until I enter criteria [Please enter job number] for the user to
enter the job number to view a record. When I enter the criteria it show me
about 50 "copies" of the same record. I have never run across this before.

any help is appreciated.

 

[Guest]

Is 'job #' the primary key for the table? It sounds like it should be. If it
isn't, have you actually looked at the table to see if there are not in fact
many duplicates of this record?

 

[Guest]

Yes the job number is the primary key, and no - there is only one record per
number.

Is 'job #' the primary key for the table? It sounds like it should be. If it
isn't, have you actually looked at the table to see if there are not in fact
many duplicates of this record?

--
Chaim

I have a query including fields job #, job name, DBuser, date entered. It
works fine until I enter criteria [Please enter job number] for the user to
enter the job number to view a record. When I enter the criteria it show me
about 50 "copies" of the same record. I have never run across this before.

any help is appreciated.

 

[Duane Hookom]

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP

Yes the job number is the primary key, and no - there is only one record
per
number.

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.

 

[Guest]

SELECT [T_Job Info].[Job Number], [T_Job Info].[Job Name], [T_Job Info].[Date
Entered], T_DBaseUsers.[Database User], T_Originator.Originator, [T_Status
Type Descriptions].Status, [T_Work Type Descriptions].[Work Type],
T_Departments.Department, [T_Contract Type Descriptions].[Contract Type]
FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type
Descriptions] INNER JOIN (T_Originator INNER JOIN (T_Departments INNER JOIN
(T_DBaseUsers INNER JOIN ([T_Job Info] INNER JOIN [T_Contract Type
Descriptions] ON [T_Job Info].[Contract Type ID] = [T_Contract Type
Descriptions].[Contract Type ID]) ON T_DBaseUsers.[DBUser ID] = [T_Job
Info].[DBUser ID]) ON T_Departments.[Department ID] = [T_Job
Info].[Department ID]) ON T_Originator.[Originator ID] = [T_Job
Info].[Originator ID]) ON [T_Status Type Descriptions].[Status ID] = [T_Job
Info].[Status ID]) ON [T_Work Type Descriptions].[Work Type ID] = [T_Job
Info].[Work Type ID]
WHERE ((([T_Job Info].[Job Number])=[Please Enter Job Number]));

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP

Yes the job number is the primary key, and no - there is only one record
per
number.

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim


:

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.

 

[Guest]

Where is T_Estimators used? How many rows in T_Estimators? I'll bet there's
one there for each row you get back.

FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type

Good Luck!
--
Chaim

SELECT [T_Job Info].[Job Number], [T_Job Info].[Job Name], [T_Job Info].[Date
Entered], T_DBaseUsers.[Database User], T_Originator.Originator, [T_Status
Type Descriptions].Status, [T_Work Type Descriptions].[Work Type],
T_Departments.Department, [T_Contract Type Descriptions].[Contract Type]
FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type
Descriptions] INNER JOIN (T_Originator INNER JOIN (T_Departments INNER JOIN
(T_DBaseUsers INNER JOIN ([T_Job Info] INNER JOIN [T_Contract Type
Descriptions] ON [T_Job Info].[Contract Type ID] = [T_Contract Type
Descriptions].[Contract Type ID]) ON T_DBaseUsers.[DBUser ID] = [T_Job
Info].[DBUser ID]) ON T_Departments.[Department ID] = [T_Job
Info].[Department ID]) ON T_Originator.[Originator ID] = [T_Job
Info].[Originator ID]) ON [T_Status Type Descriptions].[Status ID] = [T_Job
Info].[Status ID]) ON [T_Work Type Descriptions].[Work Type ID] = [T_Job
Info].[Work Type ID]
WHERE ((([T_Job Info].[Job Number])=[Please Enter Job Number]));

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP

Yes the job number is the primary key, and no - there is only one record
per
number.

:

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim


:

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.

 

[Guest]

Ok - whats causing it and how do I correct it?

Where is T_Estimators used? How many rows in T_Estimators? I'll bet there's
one there for each row you get back.

FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type

Good Luck!
--
Chaim

SELECT [T_Job Info].[Job Number], [T_Job Info].[Job Name], [T_Job Info].[Date
Entered], T_DBaseUsers.[Database User], T_Originator.Originator, [T_Status
Type Descriptions].Status, [T_Work Type Descriptions].[Work Type],
T_Departments.Department, [T_Contract Type Descriptions].[Contract Type]
FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type
Descriptions] INNER JOIN (T_Originator INNER JOIN (T_Departments INNER JOIN
(T_DBaseUsers INNER JOIN ([T_Job Info] INNER JOIN [T_Contract Type
Descriptions] ON [T_Job Info].[Contract Type ID] = [T_Contract Type
Descriptions].[Contract Type ID]) ON T_DBaseUsers.[DBUser ID] = [T_Job
Info].[DBUser ID]) ON T_Departments.[Department ID] = [T_Job
Info].[Department ID]) ON T_Originator.[Originator ID] = [T_Job
Info].[Originator ID]) ON [T_Status Type Descriptions].[Status ID] = [T_Job
Info].[Status ID]) ON [T_Work Type Descriptions].[Work Type ID] = [T_Job
Info].[Work Type ID]
WHERE ((([T_Job Info].[Job Number])=[Please Enter Job Number]));

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP


Yes the job number is the primary key, and no - there is only one record
per
number.

:

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim


:

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.

 

[Guest]

How did you get T_Estimators into your query?

If you don't need it in the query, open the query in design view and find
T_Estimators in the table display panel. Right click on it and select 'Remove
Table'. That will remove it from the generated SQL.

If you do need it in the query, then you've got to provide some criteria to
restrict what is selected from it and that relates it to the rest of the
tables in the query.

Good Luck!
--
Chaim

Ok - whats causing it and how do I correct it?

Where is T_Estimators used? How many rows in T_Estimators? I'll bet there's
one there for each row you get back.

FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type

Good Luck!
--
Chaim

SELECT [T_Job Info].[Job Number], [T_Job Info].[Job Name], [T_Job Info].[Date
Entered], T_DBaseUsers.[Database User], T_Originator.Originator, [T_Status
Type Descriptions].Status, [T_Work Type Descriptions].[Work Type],
T_Departments.Department, [T_Contract Type Descriptions].[Contract Type]
FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type
Descriptions] INNER JOIN (T_Originator INNER JOIN (T_Departments INNER JOIN
(T_DBaseUsers INNER JOIN ([T_Job Info] INNER JOIN [T_Contract Type
Descriptions] ON [T_Job Info].[Contract Type ID] = [T_Contract Type
Descriptions].[Contract Type ID]) ON T_DBaseUsers.[DBUser ID] = [T_Job
Info].[DBUser ID]) ON T_Departments.[Department ID] = [T_Job
Info].[Department ID]) ON T_Originator.[Originator ID] = [T_Job
Info].[Originator ID]) ON [T_Status Type Descriptions].[Status ID] = [T_Job
Info].[Status ID]) ON [T_Work Type Descriptions].[Work Type ID] = [T_Job
Info].[Work Type ID]
WHERE ((([T_Job Info].[Job Number])=[Please Enter Job Number]));


:

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP


Yes the job number is the primary key, and no - there is only one record
per
number.

:

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim


:

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.

 

[Guest]

Worked great - thanks!

How did you get T_Estimators into your query?

If you don't need it in the query, open the query in design view and find
T_Estimators in the table display panel. Right click on it and select 'Remove
Table'. That will remove it from the generated SQL.

If you do need it in the query, then you've got to provide some criteria to
restrict what is selected from it and that relates it to the rest of the
tables in the query.

Good Luck!
--
Chaim

Ok - whats causing it and how do I correct it?

Where is T_Estimators used? How many rows in T_Estimators? I'll bet there's
one there for each row you get back.

FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type

Good Luck!
--
Chaim


:

SELECT [T_Job Info].[Job Number], [T_Job Info].[Job Name], [T_Job Info].[Date
Entered], T_DBaseUsers.[Database User], T_Originator.Originator, [T_Status
Type Descriptions].Status, [T_Work Type Descriptions].[Work Type],
T_Departments.Department, [T_Contract Type Descriptions].[Contract Type]
FROM T_Estimators, [T_Work Type Descriptions] INNER JOIN ([T_Status Type
Descriptions] INNER JOIN (T_Originator INNER JOIN (T_Departments INNER JOIN
(T_DBaseUsers INNER JOIN ([T_Job Info] INNER JOIN [T_Contract Type
Descriptions] ON [T_Job Info].[Contract Type ID] = [T_Contract Type
Descriptions].[Contract Type ID]) ON T_DBaseUsers.[DBUser ID] = [T_Job
Info].[DBUser ID]) ON T_Departments.[Department ID] = [T_Job
Info].[Department ID]) ON T_Originator.[Originator ID] = [T_Job
Info].[Originator ID]) ON [T_Status Type Descriptions].[Status ID] = [T_Job
Info].[Status ID]) ON [T_Work Type Descriptions].[Work Type ID] = [T_Job
Info].[Work Type ID]
WHERE ((([T_Job Info].[Job Number])=[Please Enter Job Number]));


:

How about sharing your SQL view of your query?

--
Duane Hookom
MS Access MVP


Yes the job number is the primary key, and no - there is only one record
per
number.

:

Is 'job #' the primary key for the table? It sounds like it should be. If
it
isn't, have you actually looked at the table to see if there are not in
fact
many duplicates of this record?

--
Chaim


:

I have a query including fields job #, job name, DBuser, date entered.
It
works fine until I enter criteria [Please enter job number] for the
user to
enter the job number to view a record. When I enter the criteria it
show me
about 50 "copies" of the same record. I have never run across this
before.

any help is appreciated.