criteria in Select query to show last 4 entries

hi all

i have query with many rocords...what i want to to do is to put criteria to show only last 4 date entries (last 4 recent date entries)

for example i have
1 aug 17
5 aug 17
13 aug 17
15 aug 17
20 aug 17
23 aug 17

and the criteria to show only:
13 aug 17
15 aug 17
20 aug 17
23 aug 17

please help either by criteria or filter
thanks

Hi Marvin,

thank you for your quick response, please see the attached file, the data under date column is always unique, i need the criteria that to show only last 4 date entries (last 4 recent date entries).

the highlighted rows will be shown as a result.

thanks again.

Which database are you using?

Possibly:

Please Login or Register  to view this content.

Hi Kyle,

i didnt understand where to put the code and how to change it to match my columns names, by the way, please find attached screen shot where under "Progress_Date_: Date_"
should be the criteria i am asking for.

i put the following criteria
Between Date() And DateAdd("m",-1,Date())

which will show us all records in last 30 days, it is useful but i need the last 4 date entries (last 4 recent date entries).

thanks

Go to SQL view and post the SQL please

this is the SQL

Please Login or Register  to view this content.

any help plz?

Dear All,

I Solved it by creating another query.

Thanks.