date search

[balllian]

Im interrogating a range of dates in April (first two weeks) but when i put the date range in i dont pick up dates which potentially start before april and finish after the two weeks, What is the best way to pick up these instances.

BTW my start date and end date are in two columns. Any assistance on this matter would be greatly appreciated.

Thanks

 

[Crowley16]

erm, increase your date range to include the potential start dates...?

--------------------
Procrastinate Now!

 

[dhookom]

Use a criteria like:

WHERE [StartDate}<=Forms!frmDates!txtEndDate and [EndDate]>=Forms!frmDates!txtStartDate

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]