Search results for query: *

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)...

Thanks All, I will give it a go today and let you know how I get on! Cheers Vis

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

Cheers - It seems to work fine!

Thanks Naith, I will give it a go and a tweak if necessary! vis

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

Forgot to mention - using CR10 and SQL2000 Cheers vis

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

Thanks for your help - with some jiggery-pokery I have managed to sort it - I hope! Cheers Vis