Report

Question

How would I build a report that will ask user a [Percent of Weight] then ask user for the [Weight] and then display in a summary report showing items that are X% more to X% less?
 
I have the following fields I am working with:
[Weight] – Numeric – (~13,000 records)
[Percent to Search Weight] – Percent
[Weight – Percent Higher] – Formula – Numeric
[Weight – Percent Lower] – Formula – Numeric
T
This does NOT work or a few variations of this.  ☹  Seems like this should be an easy one.  I just need user to type weight and + or – X % and then display a report with the results.
 
Any help is greatly appreciated.  Be Safe!
 
Kyle McAfee
973-229-9099kmcafee@jsupor.com
------------------------------Kyle McAfee------------------------------

KyleMcAfee · Answer

Follow up to my post – If a user could just type in the weight and the report would show everything sorted by how close the weight is, that would be just a good. Another words, it would show items with exact same weight followed by items that are one pound heavier and one pound lighter and so on. If that is an easier solution, I am fine with something along those lines. Just an idea. Thanks.

Kyle McAfee

Estimating & Database Design

SHH Logistics LLC

15171 Cronewood Lane

Memphis, IN 47143

Phone: 812.989.4171 / 973.229.9099

KMcAfee@SuporHeavyHaul.com

www.SuporHeavyHaul.com

WBE Certified Business

Sign up

Login to the community