To show last record only

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
an said:
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
Click to expand...

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.
 
Thanks for your reply.

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

an
 
Sorry.

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

Thanks.
an
 
an said:
Sorry.

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

Thanks.
an
Click to expand...

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.
 
J M,

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

Thank you more one time.
an
 
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
 
Back
Top