Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. romeyp

    If statement help

    Is it possible to write a nested if statement that would get the result that I am trying to get to?
  2. romeyp

    If statement help

    I gave it a try, and you are on the right track. The "SELECT IIf" is very close to what I am trying to do. In reference to your previous question, yes my if statement is in text box on the report I create to print out to give to people to let them know how much sick and vacation time they have...
  3. romeyp

    If statement help

    Let me give you a little more info. This is the query which figures out the balance for sick time. CorSickBal: [Employee Info]![Sick Balance]+[CorrectedTimeAccrued]![SumOfSick Accrued]-[CorrectedTakenBalance]![SumOfSick Taken] The reason why it is called CorSickBal is because I began this...
  4. romeyp

    If statement help

    I am running the query manually, but I have it set up with others to run from a macros. So I could do it either way.
  5. romeyp

    If statement help

    It is in a query.
  6. romeyp

    If statement help

    Yes!!! That is exactly what I am trying to do, but I can not figure out the corret way to write the "IIf statement". Any suggestions? Thanks once again for your replies.
  7. romeyp

    If statement help

    Actually I have my certification for Excel and Access, so I can get around in each of them pretty well. The reason I use excel first is because the data that is collected from the timesheets comes from our accounting system called BST which is designed around Crystal Reports. I have to take it...
  8. romeyp

    If statement help

    OK I'll try to explain it. I have created a database for tracking vacation and sick time for my company. It tracks the sick time of each person in our company. I take the data provide on each persons time sheet and create an excel spreadsheet with everyones information on it. From there I dump...
  9. romeyp

    If statement help

    Here is my if then statement - =IIf([SickBalance]>=240,240,[SickBalance]) What it currently does is determine how many sick hours a person has accrued. If it is greater than or equal to 240 hours it display the number 240 (this is the max amount you can accrue), if it is less than 240 hours...
  10. romeyp

    Formula and max value problem

    Duane, Yes Expr2 is a field in my record source, and you are correct that I should rename it to be able to reconize it better (something I should have done over a year ago when I created this database). A quick fix for me would be if I could just subtract the sum of sick time taken from 240 if...
  11. romeyp

    Formula and max value problem

    I have a report I am trying to complete. This is the line that I am having a problem with. =IIf([Expr2]>=240,240,[Expr2]) This line feeds information into a text box on my report. Here is how it works - It is taking data from a vacation/sick report in the same database Expr2 represent the...
  12. romeyp

    Displaying/ stacking fields in a MS Access 2000 report

    I am sorry that it has taken sometime for me to reply, but my office is moving at the same time. I have pasted the SQL as you said. 1)The Employee number is found in the EmployeeInfo, Accrued, and the Taken table. 2) Each employee accrues time each month. 3) Yes table Month has each month...
  13. romeyp

    Displaying/ stacking fields in a MS Access 2000 report

    Your are correct in what I am trying to do. My problem is that we use a different numbering system for our months ie.- April =1, May =2, June =3 ect... On my report I want to display the vaction info for each employee on one page each with each month number display with the corresponding...
  14. romeyp

    Displaying/ stacking fields in a MS Access 2000 report

    I am working on a report that keeps track of Vacation time, sick time, and holiday time available to our employees. I have it all set up but the problem I am having is this information is updated each month. I want to be able to show the balance from the previous month as well as the current...

Part and Inventory Search

Back
Top