To show last record only

[an]

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]

Thanks for your reply.

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

an

 

[an]

Sorry.

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

Thanks.
an

 

[an]

J M,

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

Thank you more one time.
an

 

[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