Search results

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

It is a calculated field in my query which adds the No. of years in the field "TERM" to the "CONTREFF" field. So if a contract effective date is 1/1/2000 and has a term of 5 years, the EndTerm field would produce 1/1/2005. This is how I wrote it and that is working fine. EndTerm...

I have an EndTerm field (this is a calculated field); I want to set up a parameter query that enables me to type in a date which will retrieve any records BEFORE that date. I've used < [Enter date] and results were not right. i.e., I entered 1/1/2007 in the parameter and the results came...

missingling: Thank you....you're the greatest!

Hi there: I'm a newby..I created a 2-page form with tabs at the top. When the form opens, you do not see the tabs without scrolling up. Is there a setting of some kind that will open the form with the Tabs Visible??? Thank you for your help.