dsum search criteria (quicker way?)

M

mxp

i am just starting to use dsum to do some simple calculations and i want
to calcualte the sum of several columns.

usually i write by search criteria like this


PHP code:
--------------------
search_criteria
="=1"
--------------------


but if say i'd got 100 values to serach by how could i achieve the
following without manually writing each one out?


PHP code:
--------------------
="=1"
="=2"
="=3"
--------------------



many thanks
mxp
 
M

mxp

to answer my own question

i had assumed that the formula needed to be in the format

="=1" when in fact because its an integer and not a string it can
simply be in the format =1, which obviously is easy to drag and copy up
to any value.

many thanks
mxp
 
Top