Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-18-2018, 06:45 AM   #16
psyc0tic1
Access Moron
 
Join Date: Jul 2017
Posts: 259
Thanks: 132
Thanked 2 Times in 2 Posts
psyc0tic1 is on a distinguished road
Re: Form to Generate Report

Quote:
Originally Posted by bastanu View Post
Try =Sum([TotalVisInspected])/Sum([TotalReceived])
Man yea! that was the ticket.

I cant thank you enough for all your help!

psyc0tic1 is offline   Reply With Quote
Old 05-18-2018, 06:46 AM   #17
bastanu
Registered User
 
Join Date: Apr 2010
Location: Kelowna, Canada
Posts: 148
Thanks: 1
Thanked 48 Times in 48 Posts
bastanu is on a distinguished road
Re: Form to Generate Report

Glad to hear you got it working!

Cheers,
Vlad
bastanu is offline   Reply With Quote
Old 05-18-2018, 07:52 AM   #18
psyc0tic1
Access Moron
 
Join Date: Jul 2017
Posts: 259
Thanks: 132
Thanked 2 Times in 2 Posts
psyc0tic1 is on a distinguished road
Re: Form to Generate Report

I attached a pic of the resulting report for anyone that wants to see the outcome. Thanks again for all the help.
Attached Images
File Type: jpg screenshot.jpg (97.7 KB, 11 views)


psyc0tic1 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help - Form to Generate Report MG101 Forms 0 06-12-2013 11:12 AM
Use form data to generate a report? laxster Reports 6 11-24-2009 03:42 PM
Generate report from form syntaktik Reports 2 10-19-2009 10:36 PM
Generate Report from Form? slyvsspy Forms 3 06-28-2002 06:11 AM




All times are GMT -8. The time now is 06:33 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World