PC Review


Reply
Thread Tools Rate Thread

Creating an "F" Statement

 
 
Sher
Guest
Posts: n/a
 
      28th Jul 2008
Hello -

I need to create an "F" Statement that on one sheet I have spend plan and on
the another sheet I have an ad hoc sheet. I would like a statement that
states if a field is blank on ad hoc than it is blank on spend plan. Right
now when I delete a field on the ad hoc it puts Jan 1900 on the spend plan
field.

Any help would be appreciated.

Thank you,
 
Reply With Quote
 
 
 
 
Wigi
Guest
Posts: n/a
 
      28th Jul 2008
See
http://www.microsoft.com/communities...r=US&sloc=&p=1

Sher, please don't crosspost or provide et least a link.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Sher" wrote:

> Hello -
>
> I need to create an "F" Statement that on one sheet I have spend plan and on
> the another sheet I have an ad hoc sheet. I would like a statement that
> states if a field is blank on ad hoc than it is blank on spend plan. Right
> now when I delete a field on the ad hoc it puts Jan 1900 on the spend plan
> field.
>
> Any help would be appreciated.
>
> Thank you,

 
Reply With Quote
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Problem creating an "If" statement Pete_UK Microsoft Excel Discussion 3 21st Jul 2010 07:27 PM
Creating an "F" Statement Sher Microsoft Excel Misc 15 28th Jul 2008 10:57 PM
IIF statement in query criteria to have "Like "*" or Is Null" as the result if true bdt513@yahoo.com Microsoft Access Queries 5 19th Jul 2006 07:38 PM
Is there a "white paper" template for "statement of facts"? =?Utf-8?B?U2FsZXMgVGF4IEd1eQ==?= Microsoft Word Document Management 0 7th Oct 2005 10:01 PM
Syntax error in UPDATE statement - field name "Upper", or "Lower" =?Utf-8?B?SWdvciBHZWd1c2lu?= Microsoft ADO .NET 2 19th Oct 2004 04:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:46 PM.