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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: IanHallett
  • Content: Threads
  • Order by date
  1. IanHallett

    Concatenating fields

    Hi, I have a table with the following fields: {InvoiceNumber} {Line Number} {Text} There could be several records with the same Invoice Number, each of which will have a line number (i.e. 1,2,3, etc). The text field represents text notes added against an invoice so there could be several...
  2. IanHallett

    Crystal Reports date formula

    I have what is hopefully a simple question regarding the syntax of a date formula. I have a date field that I want to check against to see if it is before or after 9am, I have tried a number of variations of the formula below but cannot get it to work If ({TimeField})>"09:00" then 1 else 0...
  3. IanHallett

    INSERT INTO Date issue

    Hi, I have the following code which works pefectly well with the exception of the date format: DoCmd.RunSQL "INSERT INTO Timesheet (EngineerNo,ContractNumber,Chargeable,ChargeCodeNo,Hours,TimesheetDate,Rate)" _ & " VALUES (" & Me!EngineerNo & ",'" & Me!ContractNumber & "'," & Me!Chargeable &...
  4. IanHallett

    Set Current / Print date

    Hi, I am using Crystal Reports Version XI to produce an Aged Debtors Listing. I would like to be able to set the Print date (i.e. CurrentDate value) to a user defined date via a formula if possible. I can then age my report using the Aged0To30Days etc functions which are dependant on the...
  5. IanHallett

    Drop-down list from table

    I have a page that I need to create a drop-down list on with values from an Employee Table of Employee names. The value I then need to submit is the associated employee ref (separate field in original database), but I do not want to display this value on the page. Any help would be greatly...
  6. IanHallett

    Auto re-name duplicate fields in query

    I have a query that creates a SearchName field by extracting the first 6 characters of the SurName field and the first character of the FirstName field. I get duplicate SearchName field when I have for example a Peter Jones and a Paul Jones - i.e. they both return JonesP. Is there any way to...
  7. IanHallett

    CE10 Internal erro [On Cache/Page Server: servernamw.domainname]

    I have a completely new installation of CE10 running on Windows Server 2003 (previously used CE8, but won't run under 2003). I have a large number of reports accessed using the following link format : //servername/virtualdirectory/reportname.rpt?init=java These ran without problem under CE8...
  8. IanHallett

    Return previous record value in query

    I have a table which includes the following fields and sample values : J_REF PeriodEndDate Value 100067 03/07/2005 1000 100067 04/07/2005 965 100067 10/07/2005 1125 100067 17/07/2005 875 I need to query the table and return all the records including the previous period end...

Part and Inventory Search

Back
Top