Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
percentages by group
Richard Arce 
    
3 years ago
Hello,

So I feel like this question might be hard to ask, so bear with me. The database I am taking over has clients that are in two different groups. For group A, all sales come to us. For group B, we have to reimburse a company. All these clients have donated Plasma, and we sell the plasma to various researchers across the country for their projects.

when a requestor asks for samples, its usually around 15-20 samples (all of which have come from different donors). So we have a requestor name and ID, the sample ID, the amount sent, and the date sent. Is there a way to build something that will automatically keep track of how many of those samples were part of the "reimbursement group" and have it show as a percentage? There is a separate table already that has each donor and their information including what group theyre in.

Any help would be greatly appreciated. Thank you.
Kevin Robertson  @Reply  
          
3 years ago
Yes, you can definitely build a system to automatically track and calculate the percentage of samples from the "reimbursement group" using the information you have in your database. Here's a general approach to accomplish this:

1. Identify the tables and fields: First, identify the relevant tables and fields in your database. You mentioned having a separate table for donors, so you'll need to identify the fields that indicate the group each donor belongs to. Additionally, you'll need to consider the table that contains the requestor information and the sample information, which should include the donor information for each sample.

2. Retrieve the data: Write a query to retrieve the necessary data from your database. You'll need to join the tables that contain donor information, requestor information, and sample information based on their respective keys or IDs. The query should fetch the required fields such as requestor name, sample ID, donor group, amount sent, and date sent.

3. Calculate the percentage: Once you have the counts, you can calculate the percentage using the formula: `(ReimbursementCount / TotalSampleCount) * 100`.

4. Display the result: Finally, you can display the calculated percentage in a desired format. For example, you could generate a report or output the result to a dashboard or user interface.

Remember to consider any updates to the data and ensure that the tracking system is regularly updated to reflect the current state of the database. This can be done by automating the process or integrating it with your existing data management workflows.

If you provide more specific information about your database schema and the programming language or tools you're using, I can provide a more detailed example or code snippet to help you get started.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 1:16:17 AM. PLT: 0s