Search results for query: *

Perfect thanks, much appreciated.

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

Perfect thanks, exactly what I needed.

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

Thanks guys, that worked a treat. Much appreciated.

Thanks, I tried that but got exactly the same result.

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

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

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

Thanks for your response. I think I may be a little out of my depth here - Should your code be part of the query as an expression or a separate module. I appreciate that I may also be completely missing the point. Thanks.

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

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

Excellent. Thanks for your help, much appreciated.

Thanks PH, that worked a treat. How could I add to this and insert a default date (e.g. 01/01/2001) if no previous date (record) existed. Thanks.

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