latest date

[marta]

Hello,
I have a table that has the following fields:
date, name, value1
I enter data on a daily and/or weekly basis.

How do i set the criteria for a query to pull up the
latest date entered?
thanks for your help!
Marta

 

[Lynn Trapp]

Marta,
First, if you haven't done so already, you should name your date field
something other that Date. It can cause some confusion for Access. Second,
try the following query:

Select *
From YourTable
Where YourDateField = (Select Max(YourDatefield)
From YourTable);

 

[marta]

thanks

-----Original Message-----
Marta,
First, if you haven't done so already, you should name your date field
something other that Date. It can cause some confusion for Access. Second,
try the following query:

Select *
From YourTable
Where YourDateField = (Select Max(YourDatefield)
From YourTable);


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.