Aging query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CandK
    New Member
    • Jun 2008
    • 1

    Aging query

    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.
  • FishVal
    Recognized Expert Specialist
    • Jun 2007
    • 2656

    #2
    Hello, CandK.

    Could you post the MetaData for your table. Here is an example of how to post table MetaData :
    Table Name=tblStudent
    Code:
    [i]Field; Type; IndexInfo[/i]
    StudentID; AutoNumber; PK
    Family; String; FK
    Name; String
    University; String; FK
    Mark; Numeric
    LastAttendance; Date/Time
    Regards,
    Fish

    Comment

    Working...