Thanks for the Min tip. I tried the query like u wrote and added a Group By to it, since it wouldn't work without a GROUP BY clause.
But, even after putting the clause, it still returned 2 rows, not the minimum.
So, I tried a workaround as:
Select min([week ending]) as Weekend
from
Weeks
where...
I have a table(Weeks) for storing Weekend and Monthend Dates for Timecards, containing data as:
04/12/2003
04/05/2003
03/31/2003
03/29/2003
Now, based on today's date, I need to retrieve the immediate Weekend/Monthend following today from this table. How do I do it? I am running into a problem...
I have a combo box with an SQL query (Select [Skill ID] from [Skill Master];) as the rowsource, with values like:
Access 97, ADA, C++, C++ Use, COBOL
The default value for the combo has been set to '*' so that all these values show up in the list initially. But, I want to go a step further and...
We have created an .exe file from macromedia director and
captured as an .avi file by using camtasia capture software.
We want to encode this into a vcd format,but we are facing
problems like pixelation,blurredness and less clarity,when we make the file size of 320/240 pixels.
So kindly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.