Recent content by Brent Janetzki

Wow this was a quick response. I want the quadrant limits to be as follows: Q1 should be 76% and above Q2 should be 51% to 75% Q3 should be 26% to 50% Q4 should be 25% and below. The next question is how do I create this as I am new to MS Access. What is a Function in a Module?

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

So are you saying that I do the calc in a querie which will then populate the answer back into the table?

Sorry I am new to MS Access and don't understand. Are you saying that this can't be done in a table? Im trying to ce fileds alc the number of days on market between two dates ie. the listing date and the sales date, but if the property has not sold, it should use todays date so all of the days...

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