Search results for query: *

Hi does anybody know how to do the following please or give me an idea on how to start. I have a an Excel sheet with 3 columns. Date Current Status Days Left What I want to do is when a user enters a date the current status will go to e.g Build and the days left will go to 14...

Hi I have a crosstab query; TRANSFORM Count(Export_1.IATA) AS CountOfIATA SELECT Export_1.Flight, Export_1.Dest, Count(Export_1.IATA) AS [Total Of IATA] FROM Export_1 GROUP BY Export_1.Flight, Export_1.Dest PIVOT Export_1.[0-45]; What I want to do is multiply the balues in the colums by 2...

Hi I have a 3 Node Cluster consisting of 2 ES47 machine running Tru64 5.1b. I have having continual problems with CPU0 in one machine I have had HP out twice and they have replaced the bays 3 times and it runs for so long then I get another problem the a CPU. Could it be anything else other...

Hi I have a simple form, which just adds to a table with the following data. Date New Previous 01/05/06 30 20 What I want to do is the following: When the user enters a new entry the PREVIOUS field is automatically populated with whatever was entered last. So...

Hi I have multiple row containing various data in one table 0125534229 15/04/2006 10:19:13 0 ATR Line 5 No BSM 0125534229 15/04/2006 10:19:33 MC10 MC10 MCS 0125534229 15/04/2006 10:19:36 US MC10 MC10 BSM 0125534229 15/04/2006 11:53:24 US MC11 MC11...

Hi I have an Oracle table containing some 180 millions records, I want to use Access (if a good idea) what is the fastest way to to connect and retrieve records. Thanks Phil

Hi I have a recordset Private Sub ULDID_Click() Dim dbsCurrent As Database 'Dim rstHUTF As DAO.Recordset === Globally Set GULD_ID = Mid(cmbULD_ID.Value, 4, 5) GULD_Carrier = Mid(Me.cmbULD_ID.Value, 9, 2) GULD_Full_ID = cmbULD_ID.Value Set dbsCurrent = CurrentDb Set rstHUTF =...

Hi I have a form and a Subform I succesfully get the records I need to appear in the subform. I would like then to pass these records and the recordset into a report to print. How do I do that ? Thanks Phil

Hi I have a form and a subform. I search using a combo to select the records I want and create a recordset Set rstHUTF = dbsCurrent.OpenRecordset( _ "SELECT STAMP, OPCOO, AREA, FLOW, USTATE, UCAT, WEIGHT, SHC, ULDID, INFLTID, OUTFLTID, DEST " _ & "FROM HIS_HUTF " _...

Hi I have the following data in a date field 11/05/2003 01:00:00 11/05/2003 02:00:00 11/05/2003 03:00:00 11/05/2003 04:00:00 11/05/2003 05:00:00 11/05/2003 06:00:00 11/05/2003 07:00:00 11/05/2003 08:00:00 11/05/2003 09:00:00 11/05/2003 10:00:00 11/05/2003 11:00:00 11/05/2003 12:00:00...

Hi I have the following text 16.11.05 00:48:12 SMP _CASE: received fcode: 3409 16.11.05 00:48:12 SMP _AWBGRP_INS: '125-54725322' 4 'D' 'BA 215 16NOV05' 0 'PMC 76364BA' 16.11.05 00:48:12 SMP _CASE: Answer send with state: 0 16.11.05 00:48:13 SMP _CASE: received fcode: 3416 16.11.05...

Hi I'm running a Tru64 Cluster on ES45 with 4 GB Ram and San arrays over fibre interchannel. Im running Oracle 9i I have an Oracle database which reads in text files into a database. The problem is that when Oracle archives the redo logs EVERYTHING slows down and I mean everything. I have 3...

Hi I have somne text 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].loc_port 20200 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].connectname smp/smp@ba_asmpma 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].thread_no 6 The problem I have is the following changes is length...

Hi I'm trying for format an Excel sheet to make it look tider and much more like a word document table. But it has calculations in a table. Can you in Excel divide columns I need to format the layout with different Column widths and merged columns ? thanks Phil

Hi Can WORD subtract two dates both from a table and dispay the difference as an intege in another cell ? Thanks Phil

Is it possible for Word to Subtract two dates and leave an integer If so could you post me an example Please Phil

Is it possible for Word to Subtract two dates and leave an integer Phil

Hi Does anybody know if it is possible to subtract two dates which have been selected from date pickboxes and leave an integer in a field Thanks

Hi I am trying to format a date, using a wrapper function Public Function SetInvDate() As Date SetInvDate = format(GlobalInvoiceDate, "dd-mm-yy") End Function But I have noticed that the format stays in lower case and in black, rather than like Format in uppercase. What is going on Phil

Hi I'm exporting a query to a file using DoCmd.TransferText acExportDelim, "Export_AP INV DISTR", "AP INV DISTR", GlobalOUTPUTLoc & "\" & "AP INV DISTR.csv", True This works fine expect when I look at the file Supplier Description Inv Date Inv Number Net 100171 travel 08/12/2005...