Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Timesheet data & report
Good Morning to All [bigsmile] Thanks for the idea Skip, I will try it! (No time_in and time_out, are always in the same date) Thanks again!!- leniw
- Post #6
- Forum: Microsoft: Access Reports
-
Timesheet data & report
Hi All, In the company that I'm working, we have an access control system. Everyweek, we get a very simple report which is like this: 125862 3/9/2012 8:45 Employee1 125863 3/9/2012 16:49 Employee1 125864 4/9/2012 9:35 Employee 3 125865 4/9/2012 16:53 Employee 3 I decide to put theese data in...- leniw
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Text and values in one cell
Hello All!!! I have a spreadsheet which contains information from other, separate, workbooks (with links). When I use the following formula ="Afternoon Visits: "&TEXT('[salesmen-calls.xls]MAR'!$G$30;"0%") I take this result: Afternoon Visits: 28% Is there a way to have the value written...- leniw
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
-
Display max
Hello All! I have a table like this: Column A Column B Person 1 1.000 Person 2 2.800 Person 3 3.000 What I want to do is: a) find the max value in column B (Ok, I know how to this: =max(B1:B10) b) display the Person who has the maximun value Column A Column B Person...- leniw
- Thread
- Replies: 3
- Forum: Microsoft: Office
