Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

To show last record only

Discussion in 'Information Technology' started by an, Jul 28, 2006.

Tags:
  1. an

    an
    Expand Collapse
    Guest

    Hi!

    I have an append query Q_Historic to add news records in T_Historic, with
    Name and Date fields.

    When run the select query Q_Situation, based in T_Historic, show us all
    records of the same name records.
    I have to crosstab query to sum records were exist too the similar situation.

    I would like show only last record, of the same Name.

    I don´t know what to do to it:
    - in append query Q_Historic to delete last records with same Name when run
    this append query or;
    - in Q_Situation to return only last record through Date.
    - and in crosstab query, please?

    Thanks in advance.
    an
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    an wrote:
    > Hi!
    >
    > I have an append query Q_Historic to add news records in T_Historic,
    > with Name and Date fields.
    >
    > When run the select query Q_Situation, based in T_Historic, show us
    > all records of the same name records.
    > I have to crosstab query to sum records were exist too the similar
    > situation.
    >
    > I would like show only last record, of the same Name.
    >
    > I don´t know what to do to it:
    > - in append query Q_Historic to delete last records with same Name
    > when run this append query or;
    > - in Q_Situation to return only last record through Date.
    > - and in crosstab query, please?
    >
    > Thanks in advance.
    > an


    You need to define the term "last record." I am going to guess you
    want the most recent record or maybe the most recent edited record. Access
    does not keep records in a specific order, you need to provide a mechanism
    of determining that order. You may need to add a date-time created and/or
    last edited.

    Access keeps records in a kind of bucket and they may look like they are
    in order, but there is nothing but luck keeping them in that order so
    tomorrow they may be all mixed up in that table.

    --
    Joseph Meehan

    Dia duit
     
  4. an

    an
    Expand Collapse
    Guest

    Thanks for your reply.

    I would like retur only the record with last Date saved (with same Name)

    an

    "Joseph Meehan" wrote:

    > an wrote:
    > > Hi!
    > >
    > > I have an append query Q_Historic to add news records in T_Historic,
    > > with Name and Date fields.
    > >
    > > When run the select query Q_Situation, based in T_Historic, show us
    > > all records of the same name records.
    > > I have to crosstab query to sum records were exist too the similar
    > > situation.
    > >
    > > I would like show only last record, of the same Name.
    > >
    > > I don´t know what to do to it:
    > > - in append query Q_Historic to delete last records with same Name
    > > when run this append query or;
    > > - in Q_Situation to return only last record through Date.
    > > - and in crosstab query, please?
    > >
    > > Thanks in advance.
    > > an

    >
    > You need to define the term "last record." I am going to guess you
    > want the most recent record or maybe the most recent edited record. Access
    > does not keep records in a specific order, you need to provide a mechanism
    > of determining that order. You may need to add a date-time created and/or
    > last edited.
    >
    > Access keeps records in a kind of bucket and they may look like they are
    > in order, but there is nothing but luck keeping them in that order so
    > tomorrow they may be all mixed up in that table.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. an

    an
    Expand Collapse
    Guest

    Sorry.

    In adition:
    The last saved record has Date field (obligator).
    It is to this date that I mention myself.

    Thanks.
    an

    "Joseph Meehan" wrote:

    > an wrote:
    > > Hi!
    > >
    > > I have an append query Q_Historic to add news records in T_Historic,
    > > with Name and Date fields.
    > >
    > > When run the select query Q_Situation, based in T_Historic, show us
    > > all records of the same name records.
    > > I have to crosstab query to sum records were exist too the similar
    > > situation.
    > >
    > > I would like show only last record, of the same Name.
    > >
    > > I don´t know what to do to it:
    > > - in append query Q_Historic to delete last records with same Name
    > > when run this append query or;
    > > - in Q_Situation to return only last record through Date.
    > > - and in crosstab query, please?
    > >
    > > Thanks in advance.
    > > an

    >
    > You need to define the term "last record." I am going to guess you
    > want the most recent record or maybe the most recent edited record. Access
    > does not keep records in a specific order, you need to provide a mechanism
    > of determining that order. You may need to add a date-time created and/or
    > last edited.
    >
    > Access keeps records in a kind of bucket and they may look like they are
    > in order, but there is nothing but luck keeping them in that order so
    > tomorrow they may be all mixed up in that table.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    an wrote:
    > Sorry.
    >
    > In adition:
    > The last saved record has Date field (obligator).
    > It is to this date that I mention myself.
    >
    > Thanks.
    > an
    >
    > "Joseph Meehan" wrote:
    >
    >> an wrote:
    >>> Hi!
    >>>
    >>> I have an append query Q_Historic to add news records in T_Historic,
    >>> with Name and Date fields.
    >>>
    >>> When run the select query Q_Situation, based in T_Historic, show us
    >>> all records of the same name records.
    >>> I have to crosstab query to sum records were exist too the similar
    >>> situation.
    >>>
    >>> I would like show only last record, of the same Name.
    >>>
    >>> I don´t know what to do to it:
    >>> - in append query Q_Historic to delete last records with same Name
    >>> when run this append query or;
    >>> - in Q_Situation to return only last record through Date.
    >>> - and in crosstab query, please?
    >>>
    >>> Thanks in advance.
    >>> an

    >>
    >> You need to define the term "last record." I am going to guess
    >> you want the most recent record or maybe the most recent edited
    >> record. Access does not keep records in a specific order, you need
    >> to provide a mechanism of determining that order. You may need to
    >> add a date-time created and/or last edited.
    >>
    >> Access keeps records in a kind of bucket and they may look like
    >> they are in order, but there is nothing but luck keeping them in
    >> that order so tomorrow they may be all mixed up in that table.
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    Thanks I now understand what you have and want (at least I think I do
    ;-) ) I have not worked with an application that needed to do what you want.
    I would guess it is possible to do it.... I am almost 100% certain.
    However I am going to hope someone who has worked with it will come in and
    give you a solution.

    If I don't see such a reply, I will try and play with my idea and make
    sure it works, then post it. I don't have a lot of free time right now and
    it may take me a while to work out a useful solution.

    --
    Joseph Meehan

    Dia duit
     
  7. an

    an
    Expand Collapse
    Guest

    J M,

    Thanks for your interest.
    However, I opted to one of its ideas: last blank record.

    Thank you more one time.
    an

    "Joseph Meehan" wrote:

    > an wrote:
    > > Sorry.
    > >
    > > In adition:
    > > The last saved record has Date field (obligator).
    > > It is to this date that I mention myself.
    > >
    > > Thanks.
    > > an
    > >
    > > "Joseph Meehan" wrote:
    > >
    > >> an wrote:
    > >>> Hi!
    > >>>
    > >>> I have an append query Q_Historic to add news records in T_Historic,
    > >>> with Name and Date fields.
    > >>>
    > >>> When run the select query Q_Situation, based in T_Historic, show us
    > >>> all records of the same name records.
    > >>> I have to crosstab query to sum records were exist too the similar
    > >>> situation.
    > >>>
    > >>> I would like show only last record, of the same Name.
    > >>>
    > >>> I don´t know what to do to it:
    > >>> - in append query Q_Historic to delete last records with same Name
    > >>> when run this append query or;
    > >>> - in Q_Situation to return only last record through Date.
    > >>> - and in crosstab query, please?
    > >>>
    > >>> Thanks in advance.
    > >>> an
    > >>
    > >> You need to define the term "last record." I am going to guess
    > >> you want the most recent record or maybe the most recent edited
    > >> record. Access does not keep records in a specific order, you need
    > >> to provide a mechanism of determining that order. You may need to
    > >> add a date-time created and/or last edited.
    > >>
    > >> Access keeps records in a kind of bucket and they may look like
    > >> they are in order, but there is nothing but luck keeping them in
    > >> that order so tomorrow they may be all mixed up in that table.
    > >>
    > >> --
    > >> Joseph Meehan
    > >>
    > >> Dia duit

    >
    > Thanks I now understand what you have and want (at least I think I do
    > ;-) ) I have not worked with an application that needed to do what you want.
    > I would guess it is possible to do it.... I am almost 100% certain.
    > However I am going to hope someone who has worked with it will come in and
    > give you a solution.
    >
    > If I don't see such a reply, I will try and play with my idea and make
    > sure it works, then post it. I don't have a lot of free time right now and
    > it may take me a while to work out a useful solution.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  8. an

    an
    Expand Collapse
    Guest

    Ooops!
    Sorry, J M.

    I answered to another question that I placed in another place.

    I am, then, grateful for a solution.
    One more time, thank you

    an

    "Joseph Meehan" wrote:

    > an wrote:
    > > Sorry.
    > >
    > > In adition:
    > > The last saved record has Date field (obligator).
    > > It is to this date that I mention myself.
    > >
    > > Thanks.
    > > an
    > >
    > > "Joseph Meehan" wrote:
    > >
    > >> an wrote:
    > >>> Hi!
    > >>>
    > >>> I have an append query Q_Historic to add news records in T_Historic,
    > >>> with Name and Date fields.
    > >>>
    > >>> When run the select query Q_Situation, based in T_Historic, show us
    > >>> all records of the same name records.
    > >>> I have to crosstab query to sum records were exist too the similar
    > >>> situation.
    > >>>
    > >>> I would like show only last record, of the same Name.
    > >>>
    > >>> I don´t know what to do to it:
    > >>> - in append query Q_Historic to delete last records with same Name
    > >>> when run this append query or;
    > >>> - in Q_Situation to return only last record through Date.
    > >>> - and in crosstab query, please?
    > >>>
    > >>> Thanks in advance.
    > >>> an
    > >>
    > >> You need to define the term "last record." I am going to guess
    > >> you want the most recent record or maybe the most recent edited
    > >> record. Access does not keep records in a specific order, you need
    > >> to provide a mechanism of determining that order. You may need to
    > >> add a date-time created and/or last edited.
    > >>
    > >> Access keeps records in a kind of bucket and they may look like
    > >> they are in order, but there is nothing but luck keeping them in
    > >> that order so tomorrow they may be all mixed up in that table.
    > >>
    > >> --
    > >> Joseph Meehan
    > >>
    > >> Dia duit

    >
    > Thanks I now understand what you have and want (at least I think I do
    > ;-) ) I have not worked with an application that needed to do what you want.
    > I would guess it is possible to do it.... I am almost 100% certain.
    > However I am going to hope someone who has worked with it will come in and
    > give you a solution.
    >
    > If I don't see such a reply, I will try and play with my idea and make
    > sure it works, then post it. I don't have a lot of free time right now and
    > it may take me a while to work out a useful solution.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     

Share This Page