Recent content by MySki

Golom Sorry, but I'm trying to fill in the blanks with no success. FY 2006 would be 10/01/05-09/30/06. FY 2007 would be 10/01/06-09/30/07. Using your above funcion, how would I assign the values for the fiscal year.

I am working in a database where I am projecting out 4 years from the current year. For example CurrentYear = 2006, CurrentYear+1 =2007, etc. This works great for the calendar year. However, our Fiscal Year runs from October 1 - September 30. Can I assign this range to my current year so on...

I figured out what my error was in my above question. If my max or min variable was null, I just left it blank in my table, which access did not recognize. Once I put in a value (0 or 100), I was able to bring back all records. Here is my next quandry. I am trying to predict probability...

Agreed, however, my problem is that I have 4617 recors that meet the AND S. Basis Is Not Null criteria and they are still not showing up.. I double checked and they do fall into the max/min critieria so they should show up but just are not for some reason I cant figure out.

I'm back, Been trying to figure this out for the last week, but no luck. When I run my query above, I only return around 2500 records. there are 4617 employees eligible for retirement, I should be returning 4617 results. I thought maybe I had duplicate criteria, howeer, when I run an...

Got it!! You are awesome. Thanks so much for your help.. Lori

This is what I have now and when I run, I get a blank screen. Only thing I changed was adding S.RetirementPlan=P.RetPlan (because their is a distinction between the FERS and CSRS Retirement systems. Any thoughts why I'm getting a blank screen? SELECT S.DPMTL_MLG, ([SvcYr]+3) AS Yr3S...

Below is the code I currently have. I have been trying to add the join to bring in my probability with no success. the probability table is called ProbPercent and the fields are MinAge, MaxAge, MinSvc, MaxSvc and Probability. If the AgeYr and SvcYr are Between the Min/Max Age and Min/Max Svc...

thanks. I'm going to use the table idea and try to JOIN it into my query.

That's a good idea. I already have the criteria in a separate table that I could import into Access. I've never done a JOIN before. Can you point me in the right direction? Thanks!

Second question. In my previous thread, I described my "if then statment".. Iif [Age]Between 50 and 55 and [yrssvc] Between 20 and 25,"5.6%"," ") This is an imbedded if with multiple percentages. I am then trying to create a new field that classifies the perecentages into High, medium and...

Can you give me an example? Not sure How to do that. Thanks

I have developed a database that projects the probabiity of retirement for employees. I have several queires that bring the the percent probablity of requiremet for several critiera. For example: If the emp. is under FERS and is between age 50-55 with 20-25 years of service, probability for...

thanks for the quick response. I tried creating a combo box on a form and then setting the "onopen" event of the report to open the form. However, I just got the form in the background and the report parameters ran as set in the query, asking to enter the office (but not allowing you to select...

HI, I'm creating a report in Access that generates results by program office based on the the program office entered by the user. To eliminate multiple ways of inputing the office, and thus skewing report results, I want to have the user select the office from a drop-down list to generate the...