I'm struggling to find out how to get the # of active listings for a previous time period. I have seen some posts that indicated you could just select all(sold, active,withdrawn, expired) and that would give you the number for each time period. That doesnt seem right. There are going to be properties that were listed before the 7-12 month time frame that were still active and properties that are active across all three time frames if they have not sold or expired. I must be missing something. Are they just wanting new listings during these time periods? I am registered for an AI class on this next month but have a client wanting it now. Any suggestions would be greatly appreciated.