Jump to content
Sign in to follow this  

Help Me !!!!!

Recommended Posts

Hi !!!

I have a report made by my login-logout control program... Sometimes, an employee log-in and log-out several times a day... then when a see the report, this employee has several records. I need to filter theses records in the way that I see the first log-in and the last log-out of each employee, with the same date. How can I do that :

tks !!!!

Share this post

Link to post
Share on other sites

You can achive this with a self related calculation.

---User Fields---

1) NameField -- (Text,Unique) (a StaffID may be better)

2) DateField -- (Date)

3) TimeField -- (Time)

---Calculation Fields---

4) NameDateField -- name & DateToText(DateField)

Then in Relationships create a new relationship and select the file that you are currently using, then in both scroll down boxes select "NameDateField" Lets call the relationship "LoginLogoff"

Then create the following calculation fields to display the highest and lowest time related to that individual on that date from the Aggrigate functions, remember to choose the relationship name from the pop up list before selecting the fields

---Calculation Fields--- (related)

5) LoginTime -- Min(LoginLogoff::time)

6) LogoffTime -- Max(LoginLogoff::time)

You can then adjust your report to show these values when sorted by Date the Name

Hope this works for you.

Stuart wink.gif" border="0

[ September 01, 2001: Message edited by: Stuart T ]

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.