Forum Discussion

joaodd's avatar
joaodd
Frequent Visitor
2 years ago

How to include a dinamic variable into a temporary column

I have a table "REGISTRATION" with 3 fields: - StudentNumber - Date - Status This table registers any change in the student status, each time the student status changes it is registered in this ...
Need Help
joaodd's avatar
joaodd
Frequent Visitor
2 years ago

Hi lbendlin , thanks for your inputs.

The key objective is not to know how many students registrations switched to ACTIVE on each day, but rather how many have the status ACTIVE on a given date.

Thanks  

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    yes, that's what my proposal is doing - number of active students on a given day.