akaivyleaf
Programmer
I want to be able to show records from the database where the beginning date is between 04/01/01 and 6/30/01 and exclude those records that in that date range that have an ending date that is greater than 3/30/01.
I can of get the report to work with either of these statements but not with both. In other words I can get a report to print that shows all beginning dates between the date ranges, or I can get the report to exclude those that fit the ending date criteria but not both.
Could someone explain what I am doing wrong?
Thanks in advance,
Sharon
I can of get the report to work with either of these statements but not with both. In other words I can get a report to print that shows all beginning dates between the date ranges, or I can get the report to exclude those that fit the ending date criteria but not both.
Could someone explain what I am doing wrong?
Thanks in advance,
Sharon