Search results

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

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

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

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