Search results

I've created a database with forms, tables, etc....and I have one little issue I'm hoping someone can help me with... I have four fields that I want the fifth field to sum together... Field A = 1 Field B = 2 Field C = 3 Field D = 4 Field E = =Sum("Field A"+"Field B"+"Field C"+"Field D")...

I would like to know how to link fields to multiple records without using a subform in tabbed pages. I've attached an example of what I'm working on. Basically, I have a set of the same values: Service Type, Acount #, Next Service Date, etc...but I have multiple locations with multiple services...