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...
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...
Im using the following code to duplicate a record varCnt(retrieved from a combo box on the form) many times, and it only duplicates the record with the fields present on the form for that record.
The duplicate fields are [childs name] and [target 1] [target 2] (upto target 5) and then it...
actually w doesn't even need to add a week, because its an index number that realtes to a week.
so basically i need to know if i can code a button that will say. duplicate x y z and w+1.
Ive made a button on my form to duplicate a record.
But i only want it to duplicate certain fields and leave the other fields blank (another form will deal with those values).
Is it possible to do this?
and also is it possible to do this but also having the duplicate record have, say, 1 week...
i am currently self teaching this and don't know what you mean?
normalized? how else could i structure it.
I have the following tables?
Category
-CatId
-Category
Targets
-TargetId
-Target
-Category
Week Start
-WeekID
-Week Start
then....
Child details
-ChildID
-Name
-Primary Carer
-Address...
I have a table that keeps track of targets and points for kids at the school i work at and the table has these fields:
-Name
-week starting
-target 1
-target 2
-target 3
-points 1
-points 2
-points 3
etc......
Okay, now what i need to do:
Now lets use little Johnny as an example.
I entered...
I used this module code to average a number of fields based on a childs points score in a day. This works really well -
but if a child is absent for a day and all the values are null then it returns an error 6 message of 'overflow'.
Anyhow here is the module used in the query:
Public Function...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.