I have a begin date and an end date. how to abtract specific da.

D

Develloper

I have a "begin date" and an "end date". They are in seperate fields. In
the querie I only can pull out dates that are exactly the dates I put in the
input box, but I also need date that are in between. example: If my begin
date is 1/1/03 and my end date is 2/04/04, I will need all clients that I can
bill for 4/1/03 to 4/30/03. I will have to this every month, through out the
year. Everyone have different begin and ending dates and their date may
start or end in the middle of the month.
 
D

Develloper

I understand that part, but I am dealing with 2 fields not 1. OrderDate1 and
OrderendDate2 . I will have to prompt 4 times to get a range or criterias. I
am trying to avoid the user to put in 4 sepeaate dates.
I appreciate your help, is there a way?
 
Top