Re: query results show several "copies" of same record

Tech-Archive recommends: Speed Up your PC by fixing your registry

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


"SMBR" wrote:

> 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]));
>
>
> "Duane Hookom" wrote:
>
> > How about sharing your SQL view of your query?
> >
> > --
> > Duane Hookom
> > MS Access MVP
> >
> >
> > "SMBR" <SMBR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:79A189CA-3DA2-4818-9112-9C48CB0E2A0B@xxxxxxxxxxxxxxxx
> > > Yes the job number is the primary key, and no - there is only one record
> > > per
> > > number.
> > >
> > > "Chaim" wrote:
> > >
> > >> 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
> > >>
> > >>
> > >> "smboyd" wrote:
> > >>
> > >> > 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.
> >
> >
> >
.

Relevant Pages

  • Re: query results show several "copies" of same record
    ... "Chaim" wrote: ... > How did you get T_Estimators into your query? ... >>> Good Luck! ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: criteria and dates
    ... Assuming that is in fact of type DateTime, ... Good Luck! ... Chaim ... > Nevermind, I still need help! ...
    (microsoft.public.access.queries)
  • RE: Access DAO Query
    ... dim rst as DAO.Recordset ... Good Luck! ... Chaim ... > In Access 2000 DAO, what is the syntax to refer to a field in an open query? ...
    (microsoft.public.access.queries)
  • Re: access 2003 zero fill field
    ... Good Luck! ... Chaim ... > I must zero fill a text field in a query but not sure how to go about it. ...
    (microsoft.public.access.queries)
  • RE: Date in Field Returns Y for Yes
    ... Good Luck! ... Chaim ... "JanetF" wrote: ... > I have a query in which there is a date field. ...
    (microsoft.public.access.queries)