Recent content by mg2rde

To all, I need to change level2 a bit... the original is below...now i need level2 to be greater than 15 hours and then minus 15 from totalhours so do I have to insert another case statement..... thanks in advance... SELECT (some stuff), TotalHoursLevel = CASE WHEN TotalHours <= 15...

thank you very much bparkinson, you are awesome:D

To all, I need help with the following: I am writing a pass-thru query and need to write a complex case statment (for me anyway) if total hours is equal or less than 15 then LEVEL1 if total hours is greater then 15 then level1 is 15-1 and level2 is total hours -15 any help will be...

thanks...it seems quite simply now

Thanks for your help.

To all I inherited the following IIF query but it seems that there is a limitation as to how many access can handle. I would like to move the code to a Case select statement. Can someone help with the proper syntax? The code is the following: if(a.[Hospital Currently Admitted to] Like...

Thank you....saved me a lot of time.....

To all, I have a main form with command buttons that open other forms. The command buttons are set up to open the forms in filtered mode. I need to pass a value from the main form to the "other" form via the command button. any suggestions will be appreciated

thanks to all but VilaRestal your solution was dead on....thanks for moving my project forward

sorry... I am trying to update a group of checkboxes using a command button with codes. I need the codes to loop to the next if statement. I tried your with if and receive the following error:run-time error 438-object support this property or method...thanks again

I need to update various text boxes on a form...Fairly new to vba..thanks in advance The codes update one and not the others...might need a Case Select...need help with setup Private Sub Command89_Click() If ((Forms!frmMain.frmSummary!Chronic >= 3 And Forms!frmMain.frmSummary!Chronic <= 4)...