Assuming that you actually have the whole date. You either need to save it as a whole date or reverse it YYYYMM.
Two choices
Choice 1:
Go ahead and create this qry
"SELECT MAX(DATE) AS MAX_DATE, number FROM table WHERE DATE<#06/01/2003# GROUP BY number"
Then create this qry
SELECT...
Hi Michelle,
I am not sure but it sounds like you just want to create an executable. Go to File and there should be a Make [Name of Project].exe....VB 6.
Once you create the executable you can use one of the above programs to distribute it to your users.
Daisy
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.