Select query for records from the last date.

[anrichards22]

I am currently getting all the records from my Access table (CALC_TD) and sorting the result in Excel to get what I need, however, my CALC_TD table is now far to big to do this efficiently so I am trying to get only the records with the most recent date from my Access table.

Please Login or Register  to view this content.

Unfortunately my SELECT query is not working as expected. Not sure what the problem is, output seems to be random. If I change the order by to asc the result is the same as desc.

Any assistance appreciated.

[ranman256]

SELECT * FROM [CALC_TD] where [C_D] between txtStartDate and txtEndDate

[anrichards22]

SELECT * FROM [CALC_TD] where [C_D] between txtStartDate and txtEndDate

I don't know what the end date is, that is why I am trying to get only the records with the latest date.

For the time being I am just getting all the records that match Now - 90 days.