Re: Set up....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

As stated in your post from yesterday, you should not store the calculated
values.

(please stop with the exclamation points - we are trying to help and don't
like to be shouted at).

As your post from yesterday states, it is much more efficient to calculate
the number each time you need it than it is to store the calculation.

--
Rick B



"Chris" <fiona.innes@xxxxxxxxxxxx> wrote in message
news:1137504373.223806.287470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> All the values that are genreated from the calcualtions are completely
> different.
>
> Is there any other way you suggest doing this...??? Heres what i have
>
> 1 have 2 tables
>
> (a) Meal Uptake:
> (b)
> School Name* (Primary key)
> Meal Id * (Primary key)
> Cost Centre
> School Name
> No Pupils
> No tickets
> No days
> Without tickets
> Possible No meals
> Supplied tickets
> No Meals
> % Uptake
>
> What i need is when a user selects a school (from combo box list) my
> form should then display the no. pupils and cost centre which is
> related to this school.
>
> The no.pupils figure is then multiplyed by the no days (which user
> selects from combo box either 1,2,3,4,5) this gives possible no meals.
> The no. meals is then divided by possible no meals and expressed as a
> percentage for % uptake
>
> I need all these figures to be in my tables as they are going to be
> used for monthly reporting for schools based on the possible no meals,
> % uptake etc.
>
> What iv done is set up a combo box with school name, no pupils, and
> cost center but set columns so that user does not see no. pupils & cost
> center but these then appear in text boxes where iv done all the
> calculation that i stated above and these all work but dont save into
> the required fields in my tables....!!!
>
> Is there an easier way to set this up or anyway that these values can
> be saved as am comfused??? as to what to do and what code and where to
> put it HEEEEEEEEEEEELLLPPPP its doing my head in
>


.

Relevant Pages

  • Re: Set up....
    ... When you want to show a calculation, ... CostPerApple ... No Pupils ... Possible No Meals ...
    (microsoft.public.access.forms)
  • Re: Finally, a DOE plan to deal with parent deadheads.
    ... The article simply states that feds do not permit ... it doesn't say the the school cannot use state ... funds to pay for the meals of "deadbeat" parents... ... children a lunch of crackers and milk...I did not read anything about ...
    (soc.culture.hawaii)
  • Re: Forts in Chatham Area?
    ... ratios and that's all then what they know is superficial. ... used pre the days of calculators to aid quick calculation. ... it's purpose from anyone under 30 no matter what school they came from. ... Come the recession they will ...
    (uk.local.kent)
  • Re: "We Cant Just Leave it Up to The Parents"
    ... hard to make sure that their kids are healthy,” ... when many children get up to half their daily calories from school ... meals, it’s clear that we as a nation have a responsibility to meet as ... think that parents have a right to expect that their efforts at home ...
    (rec.sport.football.college)
  • Republicants continue their war on poor and middle class -- "They dont have bread?? Let em
    ... House Republicans have temporarily blocked legislation to feed school ... maneuver Wednesday to try to amend the $4.5 billion bill, ... after-school meals annually to children in all 50 states. ...
    (alt.politics)