Unable to get results with multiple attempts at this!!!

[Shigg9423]

I have a table with three fields. One of the fields is a date field (format #yyyy#), another is an ID field and the last is a "Type" field.

I am trying to return the type associated with the latest record based on the date field.

I only want one ID to show.

Therefore, the record should be:
(one ID, Date, Type) [sig][/sig]

 

[kathryn]

The easiest way IMHO, is to create a query, sort on date (descending), and choose the top 1 record to be returned. You choose top 1, by changing the All in the dropdown box on the menubar to a 1.

Hope that helps.

Kathryn

 

[MichaelRed]

But ... if the date field is truly just the #yyyy#, then the 'Top' record may not be the latest ... ????

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[kathryn]

Michael,

Good catch! I skimmed right over the format.



Kathryn

 

[Susie]

Is that because format("YYYY&quot makes it text? Then I would suggest also having a column in the query that is left as a date field for sorting purposes, and then following the suggestion above.