Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sum only some records
Thanks dhookom. It worked perfectly, and even more I understand the workings behind your suggestion. Thanks again for a simple and elegant solution. Pukeko "The Pukeko is a bold and fearless bird." - WRB Oliver.- Pukeko
- Post #5
- Forum: Microsoft: Access Reports
-
Sum only some records
Thanks MLZ, I tried your suggestion, but how does it do the summing over multiple records, checking 'logical' each time? I tried changing "[intNum1]" to "Sum([intNum1]) put it only seems to check logical on the first record for name and then biased on that either add or don't...- Pukeko
- Post #3
- Forum: Microsoft: Access Reports
-
Sum only some records
I have a form that I enter things like name and date. On the form I also have a number field (intNum1) along with a logical field next to it. I use the logical field to indicate if I want the number to be included in the sum on my report. I want the entry listed even if the number is not...- Pukeko
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
