SQL query to display only most recent date?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil @ Delfin English School - 12 Jan 2006 16:05 GMT

I have a simple programming question.

I work in a school and we have constant changes of students each week who
are paying weekly . I have to set up a query using SQL to search for

1) The date of only the most recent payment made.
2) If I want to display the students for a particular class for the coming
week how do I program that in?

Reply to this Message

TomHinkle - 12 Jan 2006 19:18 GMT

1.
SELECT TOP 1 CurrentDate FROM SomeTable Order by CurrentDate;
(May have to order by date DESC)

2. not enough info on # 2.. would need to know how you're tables are set up..

> I have a simple programming question.
>
[quoted text clipped - 4 lines]
> 2) If I want to display the students for a particular class for the coming
> week how do I program that in?

Reply to this Message

RD - 17 Jan 2006 22:02 GMT

1. See this: http://www.mvps.org/access/queries/qry0020.htm
You should be able to alter it to show the records you want.

2. What would tell you that the student is in a particular class?

>I have a simple programming question.
>
[quoted text clipped - 4 lines]
>2) If I want to display the students for a particular class for the coming
>week how do I program that in?

Reply to this Message