jamesddelaney
New Member
- Joined
- Jun 24, 2012
- Messages
- 4
i have a pp table of usernames and a date time stamp of each login. so if a user logged into a site 5 times, he would have 5 entries in the table.
i'd like to add a column to this table call login number.
<tbody>
</tbody>
what formula would you use to do the calculation for "login_number".
i'd like to add a column to this table call login number.
username | login_datetime | login_number |
james | 1/1/12 5:00 AM | 1 |
james | 1/1/12 11:00 AM | 2 |
james | 1/2/12 6:00 AM | 3 |
james | 2/1/12 5:00 AM | 4 |
james | 3/10/12 5:00 AM | 5 |
john | 1/3/12 4:00 PM | 1 |
john | 1/3/12 8:00 PM | 2 |
john | 1/3/12 11:00 PM | 3 |
<tbody>
</tbody>
what formula would you use to do the calculation for "login_number".