Search results for query: *

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

Thank you very much. Lisa

Hi I want to add a field to a formula as below if {@Outcome} = 'YES' then 'You are Correct' else if {@Outcome} = 'Maybe' then 'You could be right' else if {@Outcome} = 'NO' then 'You are Wrong' and I want to then add a field here so that when the text is displayed it will say 'You are wrong...

Hi I have a problem where I have against many records some data in one field i.e. Type Number Action Concluded Name Lisa No 1 Ring Y Name Lisa No 1 Write N Name Lisa No 1 Write M Name Lisa No 1...

Hi I have multiple records that I am displaying in a report, there could be 100 records but I only want to display the last 6. Thanks, Lisa

Hi I have 10 fields that are checkboxes there could be one ticked or 5 ticked or even 10. I have tried to do a formula like if field 1 = y and field 2 = Y then 'red and blue' else if field 1 = y and field 4 = yes then 'red and green' and so on and I need to display every possible scenario -...