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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculations in Groupings
This solution worked great. But now I have another thing to add to the mix. My report is based on a parameter query that returns either data on a specific commodity or data on all commodities. I've now added a parameter to the query to limit the dates that are returned. Results are either...- avancuren
- Post #5
- Forum: Microsoft: Access Reports
-
Calculations in Groupings
That fact that I cannot use a SQL string as the source for a control explains much of my problem. Thank you for that. I have a series of entries in a table that are weight certificates representing a number of different commodities moving in or out. The table is Certs. Relevant fields are...- avancuren
- Post #3
- Forum: Microsoft: Access Reports
-
Calculations in Groupings
I want to subtract the sum of all records in a table based on the value in a certain field from the the sum of all records that have a different value in that field (subtract the INs from the OUTs) as part of a report. I have been able to create queries that produce the desired record sets, but...- avancuren
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
