Recent content by TudorSmith

Sorry guys, I'm back again! While the Stored Procedure returns all the results I need, the code running it from the VB application is declaring that my recordset (set up from the call to the SP) is closed. My suspicions are that the SP is closing the record before it is executed. Here's my VB...

Thanks guys, It all works a treat. I never considered running SQL on the same table with an inner join to itself. Ingenious!!! Tudor birklea ~©¿©~ <>< Dim objJedi as Jedi.Knight Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

Okay Dokay! Thanks for that. I'm off to give it a try (now I understand what your saying :-) ) Stars on the way for you both if it works *Tee Hee* birklea ~©¿©~ <>< Dim objJedi as Jedi.Knight Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

Hmm...it looks interesting eorge, but the first few lines are showing the dat ayou are storing in the temp table. It would need to be populated dynamically as it will change with every "run". That's why I thought the CURSOR solution would be best...I could loop through my "source" table and...

Hi Druer Yep...that's a fair assesment. I made a mistake with my image...the second image shows the first row (with a 0) and that shouldn't be there (I was just cutting and pasting). so: If an AddOmitFlag 0 value is encountered then If there is another row for this same description then...

Thanks. that's not what I'm trying to do though. That will only return 3 rows. here's a link to a page on my website, showing what I have in my data set, and what I really want: http://www.tudorsmith.co.uk/cursor.htm I don't think I can get the results just buy doing a SELECT DISTINCT...

Yikes. I knew I'd made it to complicated. Well I don't want to remove/delete records, just want INSERT rows into a temp table (#Results). In essence, a row with a 0 in the AddOmit column inidcates that we need to omit any row with the same description (MP2) as the record to be omited. I see it...

Hi All. I'm pretty new to cursors...in fact I'm a newbie with them. I think I need to run a cursor for the following exercise. If now please advise, otherwise, could some clever person build one for me? I have a table with rows of data, where one column is identified as "AddOmitFlag". If the...

Does anyone know how to do this? I have an access report, with two specific groups (Possession & Resourcetype). For each group footer, I have a total value which is all good and well. In the PAGE FOOTER section though, the user has asked me to display all the running totals together for each...

Ha! that's exactly how I managed it! I dug about and finally came up with the solution. Thanks for the tip though...have a star :) birklea ~©¿©~ <>< Dim objJedi as Jedi.Knight Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

Hi All I have a report with a column returning values 0 & 1 (Where a task is complete or not). I have set an expression to return "NO" or "YES" accordingly. Now, in my report footer I would like a field that only counts the number of 1's. If my report shows 6 columns and only 2 have a "1"...

Are you performing the update in a form? Assuming the fields are called "Field1" & "Field2" you could manage the change in the After_Update event of Field1 Sub Field1_AfterUpdate() Me.Field2 = CDate(Day(Me.Field1) & "/" & Month(Me.Field1) & "/" & Year(Me.Field1) + 3) End Sub Of course you...

Hi All I have a Stored Procedure sourcing an SQL 2000 database. The SQL Query analyser runs the SP fine (including any parameters I pass in). the paramters are: @Year INT, @Period INT, @GroupOG VarChar(50) @Analyser VarChar(25) Now, when I bind my Crystal Report (v 9.0) to this stored...

Access version 97 Crystal Version 9 What I have is an Access database that generates a report for a procurement order. What is needed is for an email to be generated (that bit is working fine) and for the procurement report to be attached as a PDF file to the email. Now, I have the report both...

thanks Guys I thought it might be obviious! works great now :-) birklea ~©¿©~ <>< Dim objJedi as Jedi.Knight Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))