bille said:
I have limited abilities in working with Access. I am trying to obtain the
sum of fields in one column when their value in another is equal. How do I
do
this?
Could you clarify? In Access terms, Fields and Columns refer to the same
thing, so you can't have Fields in a Column. Tables can be described as
having Rows containing Columns of data, or as having Records containing
Fields of Data. The usual terminology used in Access is Records and Fields
but the other is acceptable; what is confusing is when a "blend" of the two
are used.
In what context or circumstances do you need to obtain the sum... in a
Query, in a Report, or in a Form? (You should not be storing the result of
a calculation in a Table, if that calculation can be performed, using
available data whenever the result is needed -- so I did not include that
option.)
Larry Linson
Microsoft Access MVP
