Search results for query: *

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

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...

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...

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.

It is in a query.

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.

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...

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...

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...

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...

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...

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...

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...

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...