Convert Excel formula to work in MS Access -- 2
$15 USD
Оплачується при отриманні
Need the following excel formula converted into a ms access formula
=IF(J886="","",TODAY()-J886)
where j886 is [DATEexp1]
So it should be something like IIf([DATEexp1]="","",Date()-[DATEexp1])
but i cannot get this to work. your help is grately appreciated!
ID Проекту: #8277126
Про проект
Доручено:
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database formula. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating Більше
22 фрілансерів(-и) готові виконати цю роботу у середньому за $18
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 Більше
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 Більше
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 Більше
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 Більше
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, Більше
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 Більше
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 Більше
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 Більше
Well, I think your question can be resolved free of charge: IIf([DATEexp1]=null,null,Date()-[DATEexp1])