Looking to display the last 100 records entered in database

[Trisha]

Hello,
I seem to be banging my head of the wall with this one but I am looking for a way to either display through a query with an expression or any other alternative that someone may have to display the last 100 records entered maybe based on date entered or something.
At the moment i have a query and report going form start date to end date but would also like a query/report that will just show me the last 100 records entered. :banghead:

 

[GinaWhipp]

Hmm, something like...

SELECT TOP 100 * FROM [YourTableNameHere] ORDER BY YourDateFieldHere
DESC;

 

[Trisha]

Hi Ginawipp,

Not really the top 100 by date but the last 100 records entered rather than having to enter from date to date. If i am explaining myself correctly. Sorry if i am vague.

 

[BlueIshDan]

I'm dumb lol

 

[BlueIshDan]

Do you have an auto number, or incremented index?

 

[GinaWhipp]

When you put the query in the QBE Grid you should be able to add your Between() statement but leave the date descending part, i.e.

WHERE BETWEEN [Enter Start Date] AND [Enter Ending Date]

 

[GinaWhipp]

I'm dumb lol

@BlueIshDan

Umm, did you mean to post this here?

 

[vbaInet]

It seems in this case the date has no bearing. So like Dan asked there should be an autonumber sequence that would help in determining the last 100.

The code from Gina is fine, you just need to swap the date field for the auto incremented field. If you don't then you would have to use Last.

 

[GinaWhipp]

Please post the SQL of your query here and let's see what you have.

 

[Trisha]

Thanks GinaWhipp will do when i get back to office
Thank you so very much,

 

[GinaWhipp]

Oh, okay I'll be here somewhere!