Subject Re: SQL stop sorting at middle of table
From Mervyn Bick <invalid@invalid.invald>
Date Sat, 5 Jan 2019 09:06:30 +0200
Newsgroups dbase.getting-started

On 2019-01-05 1:49 AM, Keith wrote:

> Hi Mervyn,
> Condate is a date field and your codes work very beautifully.
> However the Last_consult shows as 02/28/2018.
> Please teach me how to check the contents of condate.
> Much thanks....
> Keith

You are going to need to inspect the actual records.

In the Command Panel

select count(*) from consults where extract(year from condate) = 2018
list off

This is just to output the count of consults for the year.

select code,condate from consults where extract(year from condate) =
2018 order by condate
//all that on one line

If the last record on view in the browser is 02/28/2018 records for the
rest of the year are not in the table or the values in condate have been

select * from consults

Records for 2018 will have been added to the bottom of the table each
time so you should see them below the entry for 02/28/2018

If there are records after 02/28/2018 how to fix this depends on what's
wrong.  Please describe what the dates look like after 02/28/2018 and we
can start from there.

Each select closes the rowset opened previously but to prevent leaving
the last rowset open enter USE when you've finished exploring the table.