Sum Wildcard

[gMAC]

I have a form that has approx. 50 textbox fields that display the prices of parts. All of these field names end in Prs, (Table1Prs – Table50Prs). I would like to have a text box displaying the total of all 50 boxes. I know you can use =[Table1Prs]+[Table2Prs]+ect. this would be very long.
Can or how can you use a wild card in this statement? *Prs?

Thanks gMAC

 

[saintsman]

If all your prices end in pairs then there is no need to include this every time. You should have a column header that states that they are pairs and instead of a text field, make it a number field which will be simple to add up.

 

[simongallop]

Another way is to call all the textboxes the same in the TAG property, then you can sum by TAG

 

[gMAC]

Sorry, I should have been more specific. The “Prs” stands for Price. The fields in my table that are relating to price are named, fldPart001Prs, fldPart002Prs, fldPart003Prs, ect. There are approximately 50 fields relating to price. On my form, all of these fields are shown. I have an unbound text box (Parts Total Price) that I want to add the amount of all 50 fields. The Sum expression that I spoke of earlier would be placed in the unbound box, but would be very long. I would like to know if there is a shorter expression or a simpler way?