If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Identify closed/finalized records the month they were opened Acces
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 |
#2
|
|||
|
|||
Identify closed/finalized records the month they were opened Acces
The criteria you need is:
month(qryClosedRecords.open_time) = month(qryClosedRecords.finalized_time) I would also match the year if there is a chance that the finalized_time could be a year later. -- Daryl S "mp80237" wrote: 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 |
#3
|
|||
|
|||
Identify closed/finalized records the month they were openedAcces
Thank you so much! It worked |
Thread Tools | |
Display Modes | |
|
|