Need help please to count cases from entered date which fall in aging range: <= 0 to 5 days, = 6 to 7 days, = 7 to 10 days and = 10+ days. Worked hard to use combination of DateAdd and DateDiff formulas but it either pulls all the records or I get error messages. It's all probably simple to do and I may have been close but just frustrated now. Need for report ... please help. Thanks.
Aging query
Collapse
X
-
Hello, CandK.
Could you post the MetaData for your table. Here is an example of how to post table MetaData :
Table Name=tblStudent
Regards,Code:[i]Field; Type; IndexInfo[/i] StudentID; AutoNumber; PK Family; String; FK Name; String University; String; FK Mark; Numeric LastAttendance; Date/Time
Fish
Comment