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

[Guest]

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.

 

[Joseph Meehan]

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.

Between #2/2/1999# And #12/1/1999# For an OrderDate field, dates from
2-Feb-99 through 1-Dec-99 (ANSI-89)
Between '2/2/1999' And '12/1/1999' For an OrderDate field, dates from
2-Feb-99 through 1-Dec-99 (ANSI-92)


Don't forget the #

 

[Guest]

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?