Recent content by Carol Frangipane

Can anyone help w/my logic? I re-wrote my calculations and I thought it was working until I realized that when the "RenewNo" is equal to one, the next expiration date is incorrect. If anyone can see what I can do to get the "NxtExp" field to compute the correct date (in this case it would be...

Need to adjust this statement... Thank you for helping me with this nested iif. In the last part of the statement, I need the very last part of the statement rounded. Every time I put the "round" function in I get all the parentheses out of whack. Any help is greatly appreciated...

Hi Guys: I have got myself in a formula nightmare...I've written it so many different ways, that I forgot what exactly I was trying to do! Here is my scenario: A contract's original expiration date is mm/dd/yyyy [EndTerm] Once it passes that date, it automatically renews for nn years...

Here's what I have so far...and it works fine; however, some results have decimal places; i.e., 2.1666666. I just need the result to be the whole number. I can't seem to get it to come out that way...I've used "round"...but I must not be putting it in the right part of the formula. TEST...

Thanks a lot Brian....that worked perfectly! I really appreciate your help. Carol

I have the following Iif statement. =IIf(Year([EndTerm])>Year(Date()),0,(Year(Date())-Year([EndTerm]))/[Renew]) It is mathematically working fine; however, what I need is.. when the result is LESS THAN 1; ie .33, I would like it to display 1. I do not know how to incorporate another Iif...

You are a genius!!! I was banging my head against the wall...and all it was...was one miserable record with a NULL value! I should have figured that out! Thank you so so so so much!!!!!

I have a calculated date field in a query...if I try and sort by this field I get a data type mismatch. [CONTREFF] is a date field in a table, [TERM] is a number field in a table. I am trying to calculate the year the contract expires in the "EndTerm" field. The calculation works fine, but I...

Northwind Query...Thank you! I never would've found that SQL window! You guys are going to make me so smart. I love this forum. Wish I had found it two years ago! Thanks again... Carol

Northwind Query Please forgive me...I'm a beginner... How do you locate that code in the query? I don't see it in the query window.

In the Northwind DB, there is a query of the "Ten Most Expensive Products" After looking at it, I can't figure out where or how it knows to only pull the 10 highest price products. It's probably right in front of my nose...but it's making me crazy! Thanks for any replies...

2-column Report With A Title Spread Across Both Columns Did you forget about my question????

2-Column Report with title across both columns in page header or report header I set up the detail as 2 columns in the page setup, but the title is coming out on the left column only. I do not know how to set up the report or page header to spread across the 2 columns of the detail. Same for...

I have a 2-column report, but I want the header (for the Report Title) to be spread across both columns...also the page footer for the page no. and date. Is this possible??? Thank you.

Bob Larson...You're the Greatest! That did the trick. I will look that one up and read more about it. Thanks Again...CAROL