Search results for query: *

Hi All, I have an excel sheet where I want to have a time from cell and a time too cell and want to automatically work out the duration. IE Time From 08:20 Time To 09:50 Duration 01:30:00 I have worked out how to do the duration using the formula:- TEXT(F5-C5,"h:mm:ss") However I want...

Hi all, I have four pieces of data Main Job Number Sub Job Number Estimated Value Invoiced Value So the main job number always ends in '0' (EG 123456/0) and on the main job the estimated value is stored However all invoices are raised on the sub jobs... (EG 123456/1, 123456/2 etc...) I am...

Hi All, thanks for looking at this thread. I have a report that uses a csv file as its database, unfortunately the csv is already formatted which is rubbish, but I cant get that changed. With that in mind is there a way that I can create a formula/field to show me the value for something along...

Hi all, I have an excel sheet that looks like the following:- Acacia Avenue2 Beech Street6 High Street10 What I want to be able to do is create a worksheet that creates 2 rows for Acacia Avenue, 6 rows for Beech Street, and 10 for High Street Is this easy to do? If so how!?!? Thanks in...

Hi all, I am trying to trigger a batch file from a scheduled task. The batch is on the root of C drive and the file contains:- "C:\Program Files (X86)\Ganieda\Ganieda.exe" dial When I double click the batch files on the screen in command prompt comes up c:\>"C:\Program Files...

Hi all, I am trying to trigger a batch file from a scheduled task. The batch is on the root of C drive and the file contains:- "C:\Program Files (X86)\Ganieda\Ganieda.exe" dial When I double click the batch files on the screen in command prompt comes up c:\>"C:\Program Files...

Hi all, I am trying to create the following in Crystal Reports xi JOINS between tables RM_COMMON_ATTRIBUTES.EASTING >= CFG_MAP_REGISTER.EASTING_BLC RM_COMMON_ATTRIBUTES.EASTING <= CFG_MAP_REGISTER.EASTING_TRC RM_COMMON_ATTRIBUTES.NORTHING >= CFG_MAP_REGISTER.NORTHING_BLC...

Hi all thanks for looking at this post. I have a KX-TDA15 which has a CLI card in it. our incoming lines are analogue which go into a BRI card I believe (though I could be wrong) one line is named 'admin' and one is named 'box office' When people dial in from outside the building it comes up...

Hi all, I have a report that has the following:- Group header 1 - @random (based on the random formula) Group header 2 - Street name Details - Lamppost what I want to achieve is 40 random lamp posts but only 1 lamppost from each street, however currently I am getting 40 random lampposts but...

Hi, I have two tables. {RM_ITEM_INVENTORY_NDT_LATEST_TEST} and {RM_ITEM} {RM_ITEM} contains a unique ID (UID) and a start date and {RM_ITEM_INVENTORY_NDT_LATEST_TEST} also contains the UID that I join on but can sometimes contain records but sometimes does not. {RM_ITEM} has a date in it. I...

Hi all, I have data as follows:- Item Unique ID ReTest Due Date 10 12/01/2006 10 23/02/2010 10 29/04/2012 10 15/08/2018 I also have a parameter field...

Hi All, I have an HP DesignJet 800 (C7780B) plotter on my network. It is running a jetdirect J6057A with firmware R.25.09. We can print to it no problem. However if we try to send 2 or more prints then it gets the 2nd print 'stuck' in the memory of the printer and falls over, the only way to...

Hi All, I have a KX-TDA15 and everything works apart from the real time clock. This is making life a little diffucult, so does anybody know what chip I need to replace to make this work? Any help you can give would be appreicated. Thanks. David.

Hi All, I have a KX-TDA15 system that has two phone lines, there are voicemail on both of these lines, however on one line it is now going directly to voicemail instead of ringing for 20 seconds and then going. Can someone tell me how to cancel it? Thanks. David.

Hi All, I know there some other topics on here about random selections but mine is a little more complicated so hope for some advice! I have to produce a report that has 120 records appear in it, by selection. So on each details line I curently have the rnd() function and then sort on that...

Hi, I have a table that has records with dates in it, example: Item 1 - 2012/05/01 Item 1 - 2018/05/01 Item 1 - 2022/05/01 Item 2 - 2012/05/01 Item 2 - 2018/05/01 Item 2 - 2022/05/01 I only want each item with the next available date from today, so in the example above it would be item 1...

Hi all, I have a report that has data in the details section, and in the details section I have added the rnd () command. My group one is 3 cities, London, new york and Bristol. (field name is {RM_AREA}) I want a total of 105 records, and I want the records to be randomly picked, but I want...

Ok so im starting to use the KX-TDA15 but now I want to move onto voicemail. This system is being used in a theatre, and line 1 is the box office line and line 2 is a general administraton line. I want them both to have a voicemail box, and our system has an SMVA simplified voicemail card in...

Hi all, I have 2 external lines that come into the KX-TDA15 on a 2 port analogue trunk card. One line is a box office line and the other is a general administraton line. I want to be able to direct line 1 (Box office line) to the box office phone (which is extension 23) and I seem to have...

Hi All, I have a KX-TDA15 PBX and most of it works as expected however I am struggling to get the digital phones to show the correct date and time. When I go into date and time using the maintenance console and then the actual date and time I get an RTC error. Any ideas what this may be and how...