Recent content by LDickenson

Hi I have one field i.e. Table.Notes This field has many entries against each record and the notes are pre-fixed i.e. RECORD NO NOTE FIELD Record 1 PREFIXED WITH NoteA: sdkfskjfsldflksd PREFIXED WITH NoteB: dosdofposdf;lksf;ksfdk; PREFIXED WITH NoteC: kdsflsdkflskflsdf...

Sorted now thanks :-)

Hi We have a formula that adds various fields up i.e. pay1 + pay2 + pay3 We have added some new payment fields to the table and amended the formula pay1 + pay2 + pay3 + pay4 + pay5 The formula no longer works and appears to be seing the fields as blank rather than null - any pointers...

Thanks Already tried, tried all sorts for some reason it will not sort the colours in order, even tried formulas to sort the colours. Thanks Lisa

Hi I need to write a report as follow:- OBJECTIVE 1 GREEN OBJECTIVE 2 AMBER OBJECTIVE 3 RED OBJECTIVE 4 GREEN OBJECTIVE 5 AMBER OBJECTIVE 6 RED OBJECTIVE 7 GREEN I then need the report to group as follows GREEN OBJECTIVE 1 OBJECTIVE 4 OBJECTIVE 7 AMBER...

Thanks Ian [bigsmile] Much appreciated. Lisa.

Hi Ian Thanks, I need to acutally use financial year dates and not full years, i.e. I need to do:- 30th May 2011 to 1 April 2012 30th May 2010 to 1 April 2011 Thanks, Lisa

Hi I need to put a few formulas in a report. I have two fields:- Total Fees Date Fees Billed I need to add to a report TOTAL FEES YEAR 1 TOTAL FEES YEAR 2 TOTAL FEES YEAR 3 TOTAL FEES YEAR 4 I have been trying to write a formula but I am having trouble getting it to work - any...

Ian All the data is in the group header, I had to do it this way to get round several issues, also I have sub-reports in the group header of which the comments is one. Thanks

Hi Ian I turned the 'can grow' off, this didn't make any difference. I don't understand the second solution you recommended. Please help Thanks

Hi I am doing a report that has a Memo field for people to collate comments, I have written a report that brings all the comments ever added and I want to export this into excel which is fine, the only problem is people now want to use excel add a filter to search on a company name and it bring...

Formula used CDate ({TABLE.FIELD})

Thanks sorted now with a forumla

Hi Sorry for not being clear:- What we are trying to do it count how many times someone has logged into a system in a particular week but only want one record per day, the field that shows when the user logged in shows one record for every key stroke they took that day and records the time...

Hi I have a field that is a datetime field, I need to convert this to a date field as I need to preform a count on how many records for each day per month, at the moment it is counting how many datetime and therefore is showing hundreds of records per day when I just want it to count 1 record...