Newbie to databases and SQL, so any help will be most appreciated.
I’ve created a one-to-many DB with a subform that produces subtotals, and a subsubform that provides a Total of the subtotals for each unique master record. (thanks Ratslinger!)
Now I’m trying to create a field that subtracts that Total from a Cost field in the master table. From reading on the forum it appears that has to be done with an SQL command. I’ve tried a bunch of things, but keep getting “syntax error.” Frankly that’s where I’m in completely over my head.
Can anyone provide any guidance or suggested tutorials on how to accomplish this?
Many thanks in advance.