|
| 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
August 21st, 2009, 05:43 PM
posted to microsoft.public.access.reports
|
|||
|
|||
count number of records from a specific date
I need to count the total number of records in a report for all records that
have a hiredate the 12th of the month. I can't figure out how to accomplish this. I need it to be for the 12th of the month of the current month and year. Any help would be greatly appreciated Thanks LBS 
|
|
#2
August 21st, 2009, 06:10 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
count number of records from a specific date
You can try something like:
=Sum(Abs([HireDatd] DateSerial(Year(Date()),Month(Date()),12) )) The DateSerial() returns the 12th of this month. HireDateDateSerial() returns -1 if true Abs() returns 1 if true Sum(1) counts the number of true values in your report. This expression can be in the Report or Group headers or footers. -- Duane Hookom Microsoft Access MVP "LBS" wrote: I need to count the total number of records in a report for all records that have a hiredate the 12th of the month. I can't figure out how to accomplish this. I need it to be for the 12th of the month of the current month and year. Any help would be greatly appreciated Thanks LBS
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
