2 conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

please help me to put 2 condition in query of the date fields , i would like
to limite the query result to speific date between start date and end date or
list all dates wehther null or non null in date fields.
thanks
 
please help me to put 2 condition in query of the date fields , i would like
to limite the query result to speific date between start date and end date or
list all dates wehther null or non null in date fields.
thanks
Click to expand...

As the SQL Where clause, write:

WHERE YourTable.DateField Between [StartDate] And [EndDate] OR
[StartDate ] Is Null


Enter a start date and end date when prompted to get records between
those 2 dates, or leave the prompts blank to get all records.
 
Back
Top