i need to know how to get a number of days output for the date ranges of 10/1/2006 to 09/30/2007 for individuals with start and stop dates that are either before or after the dates above. i can get the data if the start and stop dates fall between the 2 dates, however a number of them start prior to my start date and or end after my end date.
any help?
ltazz
Last Activity: Jun 4 '07, 08:04 PM
Joined: May 23 '07
Location: Austin, TX
-
Access 2003, # of days for a given date Range.
-
once again i figured it out...
it may not be the cleanest, easiest way of doing it...
but it works.
thanks to any, and let me know if you need to know how i did it. ill be glad to give you a hand..
feel free to PM me... -
Anyone know how to make this statement work???
Trying to have it subtract a year from the first 2 months of the FY, october, november, and december.
if i can get this to work i will have no issues...
Private Sub Command0_Click( )
Me.Text1 = "# " + Me.Text37 + "" + Me.Text39 + " #"
Me.Refresh
End Sub
Private Sub Text35_AfterUpd ate()
yearit...Leave a comment:
-
Fiscal Year
How can i make it so that Access will Recognize the fiscal year 07 start at 1 oct 2006, and end 30 Sep 2007?
i know its possible, however cant figure it out.
Thanks for the help in advance you guys are great! -
I ended up figuring it out this morning...
rather than using the between clause, as i had 2 date ranges to work with.
i simply did a <= start and >= end on
that showed me all the dates starting before the last day of the month, and ending after the first day of the month...
which in turn showed me all dates that were active in that month...
thank you for your help.Leave a comment:
-
if you want it in a new field, its an append query, otherwise im not that sure.
ive been trying to get an update query to perform calculations, but it dont like me... good luck.Leave a comment:
-
access 2003, show active members for a given month...
i have looked everywhere for the answer to this question,
ACCESS 2003
I need to find have a query output a list of memberID's that are current for a certian month, and by that i mean,
if a member1 startdate is 01-apr-07 and end date is 30-sep07,
and member2 startdate is 01-oct-07 and end date is 05-apr 07
if its may, and i want to know who is current in june i want # 1 to...
No activity results to display
Leave a comment: