Search results

I have an excel formula that I have been trying to recreate on my form in access without luck. This works pretty slick in excel and if I can get it to work in access I will be on the road to saving my department about 6 to 7 hours of data entry a weeek. Here is the formula...

I have a table – Department ID DEPARTMENT DEPARTMENT_EXPLINATION I have a table – Employee_Listing This table includes: Employee_ID (Primary Key) LAST_NAME FIRST_NAME INITIALS I have a table – DISCREPANCY_LIST This table includes: DATE (Auto completes to current date) EMPLOYEE_ID (Primary Key)...

I am trying to add data to a combo box on the fly using Docmd but seem to be running into an error that I cannot find an answer to. Private Sub Descrepancy_NotInList(NewData As String, Response As Integer) intAnswer = MsgBox("The Discrepancy " & Chr(34) & NewData & _ Chr(34) & " is not...

I am trying to figure out a formula using the iif and isnull function. I am doing an on time report that looks at the Date Received, Date Required, Ship Date, Todays date and a few other things. The formula I am trying to work with is DAYS WORK DONE IN...

I have an excel worksheet with the following formula =IF(b40<50000,b40*0%,IF(b40<100000,b40*2.5%,b40*5%)) and I would like to convert it for use in access. I came up with the following: =iif([TOTAL]<50000,[TOTAL]*0%,IIF([TOTAL]<100000,[TOTAL]*2.5%,[TOTAL]*5%)) I get the following error...