goomba441

I am fairly illiterate when it comes to Filemaker as I am more used to Excel. Would you happen to have an example with correct syntax I could see? Thanks

Unfortunately, its what I was provided with at work... I'm sure I could find an updated version if I asked but for now is this possible? Thanks

Hello: I am trying to get something accomplished in a field calculation that I am not sure is possible. Basically I have some logic that tests other fields and if they add to more than 352, do one thing, less than 352, do another, and if the current field doing the calculating goes below '0' pop up a dialog box that says you cant do that. Not sure if this makes sense, but here is a butchered snipit of code that hopefully someone can follow my logic on and possibly make suggestions as to making it work: Also you will notice that I simply said "[This field]" in the code toward the end because I don't know how to reference the current field that is doing the calculation. Any help is much appreciated! Case( Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned < 352, Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned; Annual Leave Previous Balances - Annual Leave Total Hours - Annual Leave Donated Hours + Annual Leave Hours Earned > 352; 352; [This field] < 0; Show Custom Dialog [Error; You can not use hours you have not earned!; ]; "" )