pouplate limited values in a list box?

[a4aj]

populate limited values in a list box?

I have a challenge of populating just 10 latest values from a column of a table to a list ..Can anyone help me solve this please?

 

[KeithG]

How can you determine which values are the ten latest

 

[a4aj]

I am determining the latest by the date I enter! Is it a difficult task?

 

[a4aj]

Can anyone help me?

 

[KjWhal]

Can anyone help me?

Yes

If you are storing the Date entered in the table you could set the record source of the listbox/combobox to

SELECT Table.Value
FROM Table
ORDER BY Table.DateEntered DESC
[code]

Now that gets you all of them sorted by their date from most recent on, but not  just the last 10

you might be able to do

[code]
SELECT Table.Value, Count(Table.Value) AS count
FROM Table
WHERE count < 10
ORDER BY Table.DateEntered DESC
[code]

But I'm not sure if that'll work or not. Access doesn't support ROWCOUNT so I'm not sure if the only 10 records is an option.

 

[Bat17]

in the query design view you can select 'top' values, either from the property sheet or the combo box in the menubar. sort your dates descending and have them first in the query.

you will end up with something like

SELECT TOP 5 Table1.Field1, Table1.Field2
FROM Table1
ORDER BY Table1.Field1 DESC;

be aware though that this wont split a draw! if you have the same date in rows 10 and 11 it will return 11 results!

Peter

 

[a4aj]

Thanks a lot,WIll try and post my results!