If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I have a begin date and an end date. how to abtract specific da.
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. |
#2
|
|||
|
|||
Develloper wrote:
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 # -- Joseph Meehan Dia's Muire duit |
#3
|
|||
|
|||
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? "Develloper" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
Filtering on custom date field | MED | Contacts | 3 | September 17th, 2004 03:05 PM |
Making Excel generate Access-Like Reports | VJ7777 | General Discussion | 15 | September 12th, 2004 05:48 AM |
Calendar Object | Steve | Setting Up & Running Reports | 1 | May 18th, 2004 04:44 PM |
Formatting dates in Excel | bernrunner15 | New Users | 4 | May 11th, 2004 10:32 PM |