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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by avancuren

  1. avancuren

    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...
  2. avancuren

    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...
  3. avancuren

    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...

Part and Inventory Search

Back
Top