Jump to content

Help Me !!!!!


This topic is 7604 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 !!!!

Link to comment
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 ]

Link to comment
Share on other sites

This topic is 7604 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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