troubleshooting Question

More help on an expression. Multiply something by a database figure

Avatar of getwidth28
getwidth28Flag for United States of America asked on
Microsoft AccessVB Script
10 Comments1 Solution271 ViewsLast Modified:
Hello all.

Now I need to figure up the "Net" dollar figure on frmLogs.  The gross is done.

To figure out the net:
Multiply the Gross (already calculated and shown in frmLogs) by either 50% or 60%.  

To figure out whether to use 50% or 60%.
I added to tblGrades a column called NetPerc (net percentage).  Each tree species has either a value of .5 or .6.  Now I need to look up that value to multiply to the Gross figure.

I can get this to work.
In frmLogs for Net, if I put this in the expression builder "=[txtGross]*.5" that works correctly.  

A couple things I tried.
I cannot get something like this to work: "=[txtGross]*[tblGrades]![NetPerc]".  Maybe I would guess I need to somehow add whatever the syntax to it something like this: =[txtGross]*[tblGrades]![NetPerc] WHERE tblGrades.Species = Species.  IDK.
Database1683.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros