[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Help with a calculated field in Lotus Approach

Asked by wondra77 in Lotus Approach Database, Databases Miscellaneous, Miscellaneous Programming

Good Morning.

I have a Lien sale database which has two types of sales, vehicles valued over 4000 and vehicles under 4000. I have a calulated field which totals the number of days from start to finish of a sale, it works fine. The problem I'm having is vehicles over 4000 have a maximum of 120 days - and under 4000 have a maximum of 60 days allowed. To add to the equation, vehicles under 4000 can also go to 120 days if either the sale is 1. opposed by the owner 2. vehicle is registered out of state or 3. the vehicle ID has been altered.

I have single digit fields 'Y' or '' for vehicles under or over 4000, and for opposed sale, out of state, and ID altered. Field one is (TtlDaysToSale) Field two I have like this;

If(VehOver4000='Y' and TtlDays To Sale > 120, 120, If(VehUnder4000='Y' and Opposed='' and LicOutOfState='' and IdAltered='' and TtlDaysToSale > 60,60, If(VehUnder4000='Y' and Opposed='Y' or LicOutOfState='Y' or IdAltered='Y' and TtlDaysToSale > 120,120,TtlDaysToSale)))

I have tried many versions of this and can't get it to work, finally, I broke it down to the simplist version:

If(Vehover4000='Y' and TtlDaysToSale > 120,120,TtlDaysToSale) and still it doesn't work, it shows 120 days for all records over 4000.

I have been building this system for three months and have played with this off and on during that time. The program is now complete except for this. It would be very much appreciated if you could give me a hand with it. I'm using V9.8 on XP Home - duel core 5000 and two gig memory.

Thanks, Dave
[+][-]10/17/09 03:40 AM, ID: 25595524Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]10/17/09 03:40 AM, ID: 25595525Administrative Comment

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 30-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]10/17/09 09:38 AM, ID: 25596396Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/17/09 09:45 AM, ID: 25596418Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/21/09 07:32 AM, ID: 25624350Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/21/09 07:52 AM, ID: 25624544Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625