Calculations on specified records

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Need to perfrom several calculations on specified records
as indicated by two fields on a form.

I was trying to do this via recordset on a query that
contained the criteria (eg Forms![Form1]![Field 5],...)
but execution required specification of the criteria
(apparently parameters though specified in the query need
to be passed).

How do I perform the calculations on the records that are
determined by two fields on a form? That is the fields on
the form indicates which records must be considered. Is it
best to attempt Recordset on a query? If so how do I do
this or is there an alternative?
 
Charles,

It is probably easier to do the calculations within the same query where
you are doing your criteria selection, or else in a second query based
on that query. But at this stage you haven't realy given enough
information to go on. If you need more specific help, please post back
with some more detail, maybe with examples.
 
Back
Top