MrsGorilla
Rat Race Participant
- Local time
- Today, 12:43
- Joined
- May 6, 2003
- Messages
- 1,745
OK, I'll try to explain this as well as I can.
I have a report that is based on a table in an Access project with SQL. The table has one field that contains sums, and they are grouped by another field called CODE so that I have a sum of records for each code in the table. These are also grouped by region so my report looks like this: Region, Code, RecordCNT.
In my report, I have a text box in the report footer that contains the following statement: =Sum([RecordCNT]) which gives an overall number of records in the whole table.
My question is this: Is it possible to create another text box field in the report footer that will sum ALL of the RecordCNT fields IF the code is equal to, say A? This way I will get a total of all records associated with a certain code regardless of region.
Thanks for your help in advance.
Cindy
I have a report that is based on a table in an Access project with SQL. The table has one field that contains sums, and they are grouped by another field called CODE so that I have a sum of records for each code in the table. These are also grouped by region so my report looks like this: Region, Code, RecordCNT.
In my report, I have a text box in the report footer that contains the following statement: =Sum([RecordCNT]) which gives an overall number of records in the whole table.
My question is this: Is it possible to create another text box field in the report footer that will sum ALL of the RecordCNT fields IF the code is equal to, say A? This way I will get a total of all records associated with a certain code regardless of region.
Thanks for your help in advance.
Cindy