Hi All,
I hope that you can help.
I have a log file that shows events and what date / time the event occurred. I have converted this in an excel spreadsheet.
I would like to show the events as they happen during core hours i.e. 7.00am to 7.00pm?
The only way I can think to do this is to...
Thanks for that - I think that it has got it!
The only bizarre thing is that one user only worked for 7 seconds on one particular day - but knowing him, that is probably right!!!!
Thanks for your help Mad & LBass
Thanks for your reply - unfortunately for some reason the first and last record are not always Logon / Logoff - my example is not 100% accruate.
Any further ideas..?
Thanks
Vis
Hi
CR XI / Access 2003
I am currently trying to create a formula that will work out the duration that a user has been logged in to a system.
The data looks like...
User ID Action Date/Time
1 Logon 01/01/2006 07:30
2 Logon 01/01/2006 07.38
1...
Here you go - I hope that it helps.
Vis...
First Field
Catheter.Conference_Date - standard date field
Second Field
Formula Field - length of wait...
if {@Days Wait} < 7 then "Under 7 Days" else
if {@Days Wait} < 14 then "Under 14 Days" else
if {@Days Wait} < 21 then "Under 21 Days" else
if...
After a quick investigation and changing the start dates of the report I have found that where one of the group headings in 0 in the first month it goes to the bottom of the legend until it is used.
Is there anyway to stop this..?
Thanks LB - I have already tried this but with no joy!
I also tried putting the sam order in the grouping section of the report (even though it is hidden)
All,
I have created a graph in CR10 with SQL back end. It shows the number of days between 2 events for each month for each record.
I have grouped the data into...
Using a formula I have created the following groups...
Under 7 Days
Under 14 Days
Under 21 Days
Under 31 Days
Over 31 Days
I...
Thanks for your replies. I cna see that this is going to be a very useful part of Tek-Tips.!
The other exams that I was going to do were...
70-270
70-290
70-291
70-293
70-294
70-297
I have just realised that 70-297 was one of the subjects that I was planning on doing anyway! (I have not even...
Morning All,
I have decided to go for my MCSE and my dilema is which elective to go for.
The ones that appeal to me are:
70-282 (Designing, Deploying, and Managing a Network Solution for a Small- and Medium-Sized Business)
70-284 (Implementing and Managing Microsoft Exchange Server 2003)...
Hello,
I am new to Business Objects (actually a crystal user!)
Anyway I hope that someone can give some help. I have got report that shows Customer and products...
Cust_ID Cust_Name P_Code P_Desc
I would like to show customers that have purchased a certain Product (e.g. A) and have...
Thanks Naith
I think that you are on to the right lines - however I would also need the previous procedure.
As an luxurious example....
Name_ID Name Date Procedure
1 Joe 1/1 XYZ
1 Joe 12/2 ABC
2 Pete 12/2 BCD
3 Bob 14/2 CDE
1...
Hello..
I am trying to limit a report to show only procedures that took place within 30 days of each other.
The table that I am using has the following fields
Procedure _ID - Name_ID - Name - Date of Procedure - Description
I only want to show this information for procedures that have taken...
Cheers Skip,
Both databases record appointments, what happens at the appointments and produces a report about the appointment.
I would like to use the stable database to record the basic appointment details - the who, when & where (This data it populated from an organisational demographic...
I hope that somone can give me some advice / help.
I have got an old database that is on it's last legs and is threatening to fall over any day.
I have also got a stable database using SQL. What I want to do is use the stable database as a front end to store the information.
My problem is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.