Search results for query: *

I have a weekly report which if there is too much info goes onto 2 pages. Is the a way to ensure the info says on one page by automatically making the font smaller where necessary. thanks Nigel can I e-mail a support specialist the report?

I was running the Windows updated (Internet Explorer & Internet Tools)and my PC power was cut by mistake. I now have problems with my system. When my PC boots up it connects to redownload update, but always stops half way through. How can I stop this? thanks Nigel

I have a report that contains the following groups, sorted by #- #1: Contact.Address 2 - A #2: @Pcode - A #3: @Spring () - A #4: Contact.Crewman - A @Spring string is- if '/' in {Contact.SPRING} [1 to 3] then Cdate(left({Contact.SPRING},8)) I would like to add a running total field which...

thanks for your prompt help works a treat Nigel

Hi Iam trying to create a formula field that changes a string field to a number field (so I can use 'sum'in 'Type of summary' in a running total field. The string field is called Sqm and only contains numbers ie 1000- thanks Nigel (I have searched but can't find anything)

That works fine thanks Nigel

I tried {Contact.Postcode} [ 1 to Length( {Contact.Postcode} ) - 4 ] I get an error- A subscript must be between 1 and the length of the string I have got some incomplete Postal Codes or no code (not known) in the source database ie just- PR8 or L25 or blank Nigel

It may be easier to go from right to left as it is always the *last 3 characters* I want to omit. ie CH40 8SN (omit 8SN) CH1 0RB (omit 0RB) L1 4SN (omit 4SN) thanks Nigel

Iam using a formula field that trimms a Postal (Zip) code. The field is called Pcode (left(trim({Contact.Postcode}),4)) This work fine for codes like CH60 8PA etc becomes CH60. However we have Liverpool codes 'L' ie L1 4SN This causes problems and appears as L1 4. What would I use for...

thank you Nigel

I've got the first part of 2b) but I dont understand how to 'give it a page break after the group footer.' thanks Nigel

1) Great works a treat, thanks 2a) Have the *day* appear on the Report as well as the date. 2b) I'm not sure how to do this could you give me more clues is it to do with the Section expert? do I have to write a formula? thanks Nigel

A few more points please- Can a report be set to refresh with the source database automatically or when opened? How do people refresh, I would forget to press refresh button to update and report would be out of date. Also can the Report be set to- a) Add the day of week to report ie: Monday...

That works a treat thanks Nigel

It might be worth mentioning there is text in some of the contacts field in Act, in addition to dates ie the words 'Not Booked' thanks Nigel

If I ommit 'cdate' it works ie (left(trim({Contact.Aer Date}),8)) or cdate(left("01/01/02 P",8)) works...... But it sorts by first/second digit ie 01/02/02 01/01/01 01/00/01 02/01/02 etc Any way for the information to be put in day, month, year *order* thanks Nigel

It says- String (50) Nigel

I've got it to work with (left({Contact.Aer Date},8)) However sorting sorts by first two digits sort first so I am gettin 01/02/02 & 01/02/01 together thanks Nigel

I have gone Insert, field object, formulae fields, New I have created a field Aeration Date and entered Cdate(left({Contact.Aer Date},8)) When I add field to report and preview I get 'Bad date format string' Am I missing something? Thanks Nigel

Thanks for your reply The field name is Aer Date, so would this be (left({Aer Date},8)) Also where do I enter this, thanks Nigel