Trying to Sort by Special Date Function

J

jroeiv

New to this so be easy on me.

I am trying to build a query that will pull up information from th
last two dates entered in a database (this will not be consecutiv
dates). Any ideas on how to accomplish this? Thank so much everyone
 
D

Duane Hookom

Values are entered in tables, not database. Could you provide table and
field names with some sample records? Then provide what information you
would expect to see "pull(ed) up"?
 
J

jroeiv

SET DLT BP MONTH P Typ Vol
6/13/2005 SPDOPT EES STD 5x16 200501 C D 0.201
6/4/2005 SPDOPT EES STD 5x16 200504 C D 0.45

Here is a brief example of the table, I want to grab the last tw
record for multiple DLTs (2nd Column). The Set (date) will be changin
randomly, and I would like to automate this query, so that I ca
manipulate in other programs.

thanks (i hope this is what you meant)
Joh
 
D

Duane Hookom

From sample data, you would select all records since there is only on value
for DLT and two records in your table.

When I ask for sample records, I would expect to see enough records to
describe your specification.
 
Top