Search results

I appreciate the response; but this calculation just count the business days between dates selected. I need the actual business day based on the date in the field like in my example. Thanks

All, does anyone have a calculation for getting the monthly business day based on the date logged in another field by a user? Ex. completed date field is 1/12/2016 business day of the month is 8. Thanks

Ok. I put extra parenthesis around and it worked. But then I realized I forgot the else in the first part and now it tells me the "," is incorrect. IIf([status]= "Active" and [Type]= "Cost",([rate1]-[rate2]+[rate4],[rate1]),(IIf([status]="InActive",[rate1]+[rate3],[rate2]+[rate3])) AS newRate

thanks all. I'll change and post back.

the space is a typo. I'm getting wrong number of arguments or missing parenthesis

All, I am trying to make an IIF statement with three possible outcomes and not working: IIf([status]="Active" and [Type]= “Cost”,[rate1]-[rate2]+[ rate4],IIf([status]="InActive",[ rate1]+[rate3],[ rate2]+[rate3])) AS newRate It tells me i'm missing parathesis or wrong argument. I keep...

Got it. I created an copy and started from scratch. Thanks everyone

Everything is complied without errors. I will grab a backup copy and start again and see what happens.

All, using Access 2010. I am trying to push a file into production. I have a split database and 50 users. It is giving me an error when trying to make an accde: Microsoft Access was unable to create the .accde Help shows: This error is usually associated with compiling a large database into...

I got it. I just retyped it. I was copying the code and it didn't recognize the "". Thanks

this is what I'm saying; it automatically puts brackets around the name I put in quotes. If I remove them; it comes back.

All, using access 2010, I'm trying to use len in an IIF statement: Type: IIf(Len([qryMaster].[PAYROLL])<3,[”Active”],["CLIENT”]) When I run the query; it puts brackets around "Active" and "Client" and it doesn't return any values. What am I doing wrong please.

All, using 2010. I am using a barcode type and cannot get it to print where the barcode scanner will scan. I did however test it in word and it accepts it with a parenthesis () around the number. I tried to put () around the control but I am having a senior moment and can't remember how you...

thanks all. I'll try this

All, using access 2010. I was recently asked to lockdown one of the users database outside my dept. I split the database, created an accde and put a copy on all user desktop. I put the backend on a shared server. Now I find the users are used to running queries using the F11 function. I...

The switchboard is opened after a logon by users which may be the cause. This is a snippet of the code from the logon screen: If Me.txtPassword = Nz(DLookup("strEmpPassword", "tblUsers", "[lngEmpID]=" & Me.cboEmployee), "N/A") Then lngMyEmpID = Me.cboEmployee.Value 'Close logon form...

there's a mcrMaximize used on another form in the database but not in any of the switchboard properties

The switchboard is the one created with Switchboard manager by another developer. this is the code On Open event: ' Minimize the database window and initialize the form. ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0 AND [Argument] =...

All, using 2010. My build in switchboard used to open in the center. all of a sudden; it is opening full screen. I tried playing with the auto center controls to no avail. I know it's something simple and this is driving me crazy. Please help

O. Ok thanks for the assist