Hi, I am creating a Database and I am baffled how to make the following If Statement Work in a table. =IIf(IsNull([Sold Date]),Date()-[Listing Date],[Sold Date]-[Listing Date])
I want to count the number of days between the list date and sale date, but if the sale date is blank, I want to calculate it from todays date. The problem is that MS Access gives me an error that this formula cannot be used in a calculated table. Any ideas.
I want to count the number of days between the list date and sale date, but if the sale date is blank, I want to calculate it from todays date. The problem is that MS Access gives me an error that this formula cannot be used in a calculated table. Any ideas.
If Statements in MS Access Tables
