What I am trying to do is create a form with multiple buttons to select First : The Location
Then: The Fiscal Year
Finally I want to create a button/ query to go through the table and find the dates with in a 2 weeks span....Like if I select Daytona FY14 and then the Pay period would be 1 it would query for the first 2 whole weeks of fy14....:banghead: Unfortunatly I am unsure what to do unless I go through and seperate each one with something like a DateDiff() and I think that may be teadious.
To sum up what I have done so far.......I am creating a database in which one form allows users to input their sick leave annual leave...ect. into a table. From that I have created another form for the administrators to open these into sperate reports based on the fiscal year and or fiscal month and into small 2week intervals.
Then: The Fiscal Year
Finally I want to create a button/ query to go through the table and find the dates with in a 2 weeks span....Like if I select Daytona FY14 and then the Pay period would be 1 it would query for the first 2 whole weeks of fy14....:banghead: Unfortunatly I am unsure what to do unless I go through and seperate each one with something like a DateDiff() and I think that may be teadious.
To sum up what I have done so far.......I am creating a database in which one form allows users to input their sick leave annual leave...ect. into a table. From that I have created another form for the administrators to open these into sperate reports based on the fiscal year and or fiscal month and into small 2week intervals.