Search results

I know the theory behind what i want to do, but need some help programming this into my report. I have a field that displays a running sum (over group), but what i want is either this same field or a 2nd field to display that same information but i want it to run through a module that does...

well basically i have a field that displays a running sum, and what i want it to display is the running sum upto 350 and then start from 0. What i was thinking, is it possible to code the text box that displays the running sum to store the value of the running sum, but the code says only show...

it is also really important (actually more important) that after reaching 350 it is set to 0 and the additional points carried

ok, i kinda get this, BUT how would i insert this to the footer and make it relevant to the running sum property?

I have a running sum on a report. What it does is add up points students at a school get each week. now the students get bronze award for reaching 75 points, silver for reaching 150, gold for reaching 250 and platinum for reaching 350 points. when they reach 350 points any additional points...

Sorry to be clearer. I want the targets to be from the same rocrd of obviously that child, and from the same week as the last record(date wise) for that child. At the moment it displays the average points score for all weeks on record, in order, but each week may have different targets related...

the form get the other records straight from the fields on a query.

I've designed the following report but cannot get it to do what i want. The source of the report is all from the same query. What i want is for the targets(1-5) to be displayed based on the record from the last set of fields displayed on the bottom section of the form. here are the print screen...

I've opened a merged word document from a button on a form on my database, but is it possible to also have it set the data source on the word document to the current database when it opens it from the form button? Im using access 2003 btw. Thanks

excellent, appears to have done the job, Thankyou

Thanks for that, but im not any wiser on what to do? Im new to this, and i grabbed 2 bits of code and put them together, and fiddled around a little, kinda trial and error. the problem is it does what i want, but it just comes up with the error if there are no duplicates already, but when there...

using ACCESS 2003 This code should do what I want, and it seems to, but every time i run it it says: No Current Record when i ctrl+break it the debug get hung up on the end sub. heres the code, any ideas? : Private Sub Command16_Click() On Error GoTo Err_Command16_Click Dim i As Integer, cnt...