Date Formula in a Table

[zmbaker]

I need help creating a formula/expression that will do the following.

Will check yes/no box based on the following criteria



1. If Box1 says yes
2. If Box2 date is greater than current date

anyone have any ideas?

[June7]

Is Box1 a yes/no checkbox?

Try:

=IIf([Box1] AND [Box2]>Date(), True, False)

[zmbaker]

Yes box 1 is a yes/no box.

[June7]

Did the suggested expression work?

[zmbaker]

The statement almost works, I think it needs to be an OR statement rather than an AND statement but the word OR wont work. Any Ideas?

[June7]

OR should work.

What do you mean OR won't work - what happens?

[zmbaker]

Well I got this forumla to work in the Form, but I cant get the answer to populate in the table that i need it to. Is that not possible?

[JoeM]

Typically, you do not want to store calculations at the Table level. Even though Access just recently starting letting you do this, most programmers avoid it, because it kind of goes against the rules of Relational Database theory, and is not compatible with other database programs (i.e. if you ever needed to convert the data table to SQL, you wouldn't be able to do it).

As a general rule of thumb, anything which can be calculated should be done on the Query, Form, or Report level. There is seldom a good reason to store it at the Table level anyhow, as pretty much anything you can do with a Table (use as a Data Source, export, etc), you can also do with a Query.

[June7]

What JoeM said ...

However, saving calculated data can sometimes be desirable and that requires code. I don't think in this case saving the calculated value is warranted.