dsum search criteria (quicker way?)

  • Thread starter Thread starter mxp
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSUM Date Criteria 3
Dsum Help 0
dsum or sumproduct ? 3
Dsum Problem with date criteria 1
Access Dcount (multiple criteria) 3
DSUM criteria 3
DSUM 2
DSUM Not Very Convenient 2

Back
Top