Convert Excel formula to work in MS Access -- 2

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

What is dateexp1 ? A field name ?************************************************************************

Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I More

A proposal has not yet been provided

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need the following excel formula converted into a ms access formula. =IF(J886="","",TODAY()-J886) I have been u More

Hi im an expert in .Net and vba applications What you need to implement is the following Dim o As String Dim s As String s = "01/08/2015" o = IIf(Not IsDate(s), "", DateDiff("d", s, Date)) Regards Carlo More

Here you go... Formula: IIf(IsNull([TestDate]),"",Date()-[TestDate]) Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I More

Hi, I have right formula for you. I tested, it is working. Hope, you are good people and will not leave me without award ;). IIf(IsEmpty([DATEexp1]),"",Date()-[DATEexp1]) Best regards, More

You should use this: if Nz([DATEexp1],"")<>"" then [DATEexp1]=Date()-[DATEexp1] Thanks for reading my proposal.

I have over 8 years of experience working with MS Access applications. Have developed a number of database applications using MS Access VBA. Could design reports to any level of complexity. Development of fully normali More

Hello. More 20 years programming experience. I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------- More

Hi, below is your solution: If condition_1 Then result_1 Else result_else End If If isNull(DATEexp1) Then result="" Else result=DateDiff("d", Date(), DATEexp1) End If Please share more More

Hello, ------ Solution ------ IIf(IsDate([DATEexp1]), Null, DateDiff('d', Date(), [DATEexp1])) ------Explanation ------ In database date are not same as string, so comparing them with empty string doesn't g More

I will give you formula in Access as below, Because it is very simple. So I don't want you pay money with this. Please let me know if my formula is true when you finished tested it. 1----------------> IIf(len([Date1]) More

We are happy to provide you with this proposal. We have deployed various MS Applications like Inventory control, school management system, Payments and billings and so on. Our vast experience makes a perfect fi More

Good Day Sir, I am a IT Professional with 6 years of experience. I can provide the customized result based on the place of use of the code. I mean is it a macro or a calculated field or query. Please use the fol More

Hi, I'm an electronic and computer engineer with expert knowledge of Microsoft Excel,Microsoft Access and VBA programming. I reviewed specification You gave and I'm very interested to work on your project. I can a More

A proposal has not yet been provided

Well, I think your question can be resolved free of charge: IIf([DATEexp1]=null,null,Date()-[DATEexp1])