I want to create a report that shows the number of records of specific field and sort it monthly, and also I have a weight field that I want to sum all records in one month.
I don't know what should I do!
(I have month field in the table)
The very last sentence sounds not good for me.
What you store in this field ? Months for which year ?
If you also have a field where you store the dates you should remove this field (with months) because you can calculate the month based on the date.
Now, about the bold sentence:
Each record has all fields so the number of records is not dependent from a specific field.
So, I think that you wish to say that you wish to filter only those records that meet a specific criteria in that field.
In this case there are 2 approaches:
1) Create a query that return only the records that meet criteria then base the report (the record source) on this query;
2) Create the report based on the table/query that return all records and open it from VBA by using the
where clause.
If the criteria is variable and you decide to use 1) then the query must be a parametric one.
After you design the report use
Group in order to group the data.
For create totals (sums), ask again after you have the report.
If you wish, you can upload the database (Access 2003 or 2007) in order to take a closer look to your design.
Good luck !
