|
-
May 29th, 2000, 10:38 AM
#1
Thread Starter
Addicted Member
I'm trying to retrive all the info in a table that falls in the current month
this is what I tried
SELECT ClientData.Address, ClientData.Name, ClientData.LastWork, ClientData.NextScheduled, ClientData.CustomerType, ClientData.JobStatus
FROM ClientData
WHERE (((ClientData.NextScheduled) Like (ClientData.NextScheduled)=Date()))
ORDER BY ClientData.Address;
it doesn't work
I don't think I'm using =Date() the right way
Magiaus
Visual Basic 6.0 SP5
Visual C++ 6.0 SP5
The only sovereign you can allow to rule you is reason.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|