Reply to thread

Message: [QUOTE="mp80237, post: 13676097"] Hello I have a query, qryClosedRecords, where I need to report if the records finalized/closed the same month they opened. So if it opened #10/05/2009 06:05# and finalized/closed #10/25/2009 21:59# I need to mark it as being finalized/closed the month it was open. Field for Date Opened = qryClosedRecords.open_time Field for Date closed = qryClosedRecords.finalized_time And if it opened #08/03/2009 21:25# and finalized/closed #9/23/2009 12:45# I don't want to count it because it didn't finalize/close the month it was opened. I need to do this in a query because I will be taking this data into a crosstab query, then pulling it into excel thru a macro, which I already have setup. This is strickly for reporting. There will be no end user viewing this, no forms will be created. Identify closed/finalized records the month they were opened using Microsoft Access [/QUOTE]