If statement

[nike2000]

Hi,
I am looking to display on a form in an individual field those records that are after a certain date. The date is 01/01/2000, there are records prior and after this date.

I have composed the below If Statement but it isn't working!!!
[Trade date] is the other date field on the form that I am working with.

=IIf(([Trade Date]>(1/1/2000)),"No","Yes&quot

Can someone tell me where I have gone wrong?
Thanks

 

[coco86]

Are you getting an error or are you getting inaccurate data? If you're getting an error, try moving the if statement into your query:

NewFieldName:IIf(([Trade Date]>(1/1/2000)),"No","Yes&quot

and then setting the control source for the field to NewFieldName

 

[BobAtHome]

Try putting hash marks around the date so Access knows it is a date - as shown below.

=IIf(([Trade Date]>(#1/1/2000#)),"No","Yes&quot

 

[Aubs010]

Something that I found with Access2002 (XP) is that in reports/forms, say you have a textbox Name: "Trade Date", then in the Control Source you have the formula:
=IIf(([Trade Date]>(1/1/2000)),"No","Yes&quot

it would return an #Error message.

The reason, is that the name is "Trade Date". in the formula, you are referencing that. so as an example:
IIF(a < 10, make a 20) basically, it's a loop.

Try renaming the &quot;Name&quot; to say &quot;Trade Date_Item&quot;

Hope it helps
Aubs

 

[nike2000]

Thanks for your help.
Problem now resolved.
Thanks
Nike