Search results for query: *

lbass Thanks your method appears to be working. I now just have to change it slightly to work with odd numbers of records as well. Thank you all for your help Deleco

Ok i can done that thanks I returned 3 records, now i need to suppress the middle/2nd one. For example below. 3 Surv 2 Surv 1 Surv I only need 3 and 1 3 Surv 2 Surv 1 Surv Deleco

Hi wouldn't that give me the bottom 2 0015 10/05/2005 3 Surv 0012 10/01/2005 3 Surv I need the last (oops just realised my mistake) surveillance and the surveillance that happend before the last but one surveillance. Hope that makes sense. What i need is the last record...

Hi people, I have a list of records as follows 0007 16/01/2003 3 Surv 0008 10/07/2003 5 Surv 0012 10/01/2005 3 Surv 0015 10/05/2005 3 Surv What i have been asked to do is compare that last surveillance with the last but one surveillance. So what i want is a formula i can use or something...

Thank you,,, running totals did the job Deleco

VisitNum Assessor ChrgDays DateFrom DateTo 098211 Dean 5 01/06/05 02/06/05 5 11/06/05 12/06/05 Total 10 075535 Ben 3 15/09/05...

Hi, The details are just the Dates. Obviously i get the correct total if there is only one set of dates, but when there are multiple dates per visit this is when it becomes a problem. The reason being that the value i need to SUM is in the VISIT_HEADER table and not the ASSESSOR_BOOKINGS...

Hi, I have a bit of a dilema, i think it should be really easy but i just can't seem to get my head around it. I have a table VISIT_HEADER and this holds information about the VISIT i.e Charge Days and the Visit Type. Then i have an ASSESSOR_BOOKINGS table which holds the dates of the Visit...

Naith, Thanks very much for your assistance. Didn't know you did not have to use the system summary. Cheers Deleco

Naith, Yes i did try that. If i do that then the report will not let me do a summary on the field. The summary is what i want to see. At the end i want to hide all the details and just show the summary to the user. The message i get from the report is "A summary has been specified on a...

Below is the what i am trying to do Assessor Grade WorkDays RealWorkDays Dean LA 1 1 Dean SA 1 0 Dean HJ 1 0 Peter UI 3 3 Peter SA 3 0 Peter HG 3 0 Harry SA 1 1 HArry RE 1 0 Totals 14 5 As you can see I have Assessors who can have multiple Grades. This is the problem...

I do set sDayAss at the bottom of the function. I want this Var to be kept so it can be checked against the previous detail line. Also the details of @WorkDays is un-important because if i change the @Workdays to 1 then i still have the problem. Deleco

I use this formula in my report NumberVar lPartDays; StringVar sDayAss; StringVar sTemp; sTemp:="ppppp"; If sDayAss = {TBLASSESSOR.STRKNOWNAS} then lPartDays:=0 else lPartDays:={@WorkDays}; sDayAss := {TBLASSESSOR.STRKNOWNAS}; lPartDays This Formula is supposed only give me...

Sorry checkai. thanked the wrong person. Your the genius ;) Your solution worked a treat... Deleco

Thanks Chiph! That worked great :) Deleco

That copies the Table structure but not the data. Is there any way to keep the data??? Deleco

Hi, I have the following code Dim dsShoppingBasket As DataSet Dim dtDelegates As DataTable Dim dsCompiled As New DataSet Dim dtShoppingBasket As New DataTable dsShoppingBasket = Session("dsShoppingBasket") dtDelegates = Session("dtDelegates")...

Hi All, I think i used fhlee's technique. I added the checkboxes to a collection object and named them relevantly. I then looped round the collection did some string manipulation with the names and whooped -de-doo. It worked with only one loop and one if statement. A lot more tidier and...

Thanks i'll give these things a try... I'll let you know Deleco

Hi all, I am having a bit of a nightmare i am creating controls at runtime in a panel, in another panel and then inside a table. The only way i can figure out how to access these dynamically created controls is with this massive loop/if structure. Does anyone know of an easier method. For...