Search results

Hi I have spent several hours now staring at my screen trying to work out what the below converted excel to MS Access formula would be =IF(AND(N2<=J2,N2>K2),1,0). I'm a Real Estate Agent and I am analysing the price range method sales method i.e where a property is listed for sale in a price...

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...