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
|
|||
|
|||
Calculating Dates
I have several queries wrote where I have set the criteria to input the
[beginning date]and[ending date] and I want to capture all the data in between. I also have a lookup field that allows me to select the Pay Period Ending. Is there a way to query on the [Pay Period Ending] field -14 days. I thought this might be easier since the end user always knows the Pay Period Ending Date if it would automatically caputre all data 14 days prior to that. |
#2
|
|||
|
|||
Calculating Dates
I want to capture all the data in between.
This will capture all the data in between. Between [beginning date] And [ending date] Is there a way to query on the [Pay Period Ending] field -14 days. Between [Enter Pay Period Ending] -14 And [Enter Pay Period Ending] "Melinda" wrote: I have several queries wrote where I have set the criteria to input the [beginning date]and[ending date] and I want to capture all the data in between. I also have a lookup field that allows me to select the Pay Period Ending. Is there a way to query on the [Pay Period Ending] field -14 days. I thought this might be easier since the end user always knows the Pay Period Ending Date if it would automatically caputre all data 14 days prior to that. |
#3
|
|||
|
|||
Calculating Dates
Melinda
In your query, in design mode, select the [Pay Period Ending] field along with your other fields. In the Criteria beneath that field (assuming it is a date field), put something like the following: Between [Period Ending Date] - 14 And [Period Ending Date] Yes, both of those parameters are identical. This way, Access will only prompt once. Regards Jeff Boyce Microsoft Office/Access MVP "Melinda" wrote in message ... I have several queries wrote where I have set the criteria to input the [beginning date]and[ending date] and I want to capture all the data in between. I also have a lookup field that allows me to select the Pay Period Ending. Is there a way to query on the [Pay Period Ending] field -14 days. I thought this might be easier since the end user always knows the Pay Period Ending Date if it would automatically caputre all data 14 days prior to that. |
#4
|
|||
|
|||
Calculating Dates
At the present I am capturing all the data by prompting the end user to enter
the [beginning date]and[ending date]. I thought possibly there might be a way to set the query up to capture all the data by just prompting them to enter[pay period endingdate] and the query would calculate the 14 days of overtime earned --14 days prior to pay period ending. Kind of confusing I know. The query is working as it is, but it just seems like I should be able to eliminate some of the parameters. Thanks "KARL DEWEY" wrote: I want to capture all the data in between. This will capture all the data in between. Between [beginning date] And [ending date] Is there a way to query on the [Pay Period Ending] field -14 days. Between [Enter Pay Period Ending] -14 And [Enter Pay Period Ending] "Melinda" wrote: I have several queries wrote where I have set the criteria to input the [beginning date]and[ending date] and I want to capture all the data in between. I also have a lookup field that allows me to select the Pay Period Ending. Is there a way to query on the [Pay Period Ending] field -14 days. I thought this might be easier since the end user always knows the Pay Period Ending Date if it would automatically caputre all data 14 days prior to that. |
Thread Tools | |
Display Modes | |
|
|