Expression Help Needed

[msmit8]

I have a form that is updated once a month for40 users. Each user is a separate entry on the form. I created a text box that Iwould like to sum the total of entries for 39 different (A4, AN, AX, CB, etc.etc. etc.) entry text boxes. Some of the 39 text boxes will not always befilled in. Any help guiding me with the correct expression to use would begreatly appreciated.



This seems like it should be easy, but I can’tseem to figure it out.

Thanks!
Matt

[ranman256]

I dont think you have 39 text boxes, but rather 39 records on the data grid. right?
I think you want a query to sum each Code. (A4, AN, etc)
right?

[msmit8]

Yes, there are 39 records on the form (I think that's the same things as the data grid).

I don't think I want a query...please correct me if I'm wrong.

I'll try and explain what I'm doing a little better. Each of the 40 users is a separate entry on the form. I want each entry on the form to sum the total of the 39 records on the form for each user that I'm entering data for.

Thanks, Matt

[ranman256]

yes, query. Turn on summation totals.

[msmit8]

Still not sure on using the query. If this is what I need to do, what field do I need on the query to make this work?

I've attached a screenshot to give you a visual. The screen shot is of the form I'm using. Each field is filled out, each month for the 40 users. The total should sum the A4, AN, AX, etc, etc, fields for each user.

[June7]

This does not look like normalized data structure. If you have a field for each user, then you are making life difficult because summing these 40 fields will be a very long expression.

Nz(A4) + Nz(AN) + .... +Nz(UB)

Usually calculated data should not be saved into table. Calculate when needed.

[msmit8]

That worked. Thank you very much! Mystery solved.