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]![
Maybe I would guess I need to somehow add whatever the syntax to it something like this: =[txtGross]*[tblGrades]![N
etPerc] WHERE tblGrades.Species = Species. IDK.