|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 27th, 2004, 11:26 AM
|
|||
|
|||
|
Access query help with checking dates
I am trying to make a SQL statement query in MS Access that will check to see if a date has occurred and another one that can tell when a date has not yet occurred. Can anyone tell me what that would look like? It is to check and see if a Sow(pig) is not pregnant. If you need to see my DB structure I will post it, just let me know. Thanks Chris
|
|
#2
April 27th, 2004, 05:26 PM
|
||||
|
||||
|
1. where datefield < date()
2. where datefield > date()
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Access query help with checking dates |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
