2007 ACCESS IIF Formula to Select all values

emelendez80 emelendez80 is offline

New Member

Join Date: Nov 2009

Posts: 1

19th Nov 2009

Good afternoon,

I have the formula below and I'm trying to change it to give in all the values in this field minus 2008 (without actually putting 2008. this will change to wanting everything but 2009 next year and so on). The fasle statement right now gives me only 2007 but I need to change it to give me everything but current year -1. I tried to change this and everything so far has not work. Please any help would be great.

IIf(Month(Now())>=12,Right([Calendar Year],4),Right(Str(Year(Now())-2),4))

« "Filling in blanks" in a Word doc | Diagnostics Software »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create Formula Using Select Values of a Cell	Harpo	Microsoft Excel Worksheet Functions	3	11th Nov 2009 08:52 AM
Able to select multiple values in a drop-down list in Excel 2007?	ast	Microsoft Excel Misc	3	4th Sep 2009 04:03 PM
Formula to select values	Emece	Microsoft Excel Misc	1	26th Jan 2009 07:38 PM
Using a formula to select a cell using the row and column values	RodneyN	Microsoft Excel Worksheet Functions	7	30th Dec 2008 08:15 AM
Select row in formula in excel 2007	rslc	Microsoft Excel Programming	2	8th Nov 2008 03:00 AM