I am intermediate when it comes to building a database. Unfortunately, what I
need either goes beyond my knowledge or I just forgot how to do it.

I am building a db for my business. The db is not online, just for me to
keep track of items, costs, expenses, so on and so forth. Right now I am
trying to tie in a totals box for the following:

Sale of the item - the % of our commission - expenses = what's left

As simple as that sounds, I don't want a lot of subforms and would rather do
it in a dlookup, or any other way that wouldn't clutter the design view.

The expenses are in several different tbls. (gas, copies, telephone calls,
etc.) The information I need for each will conflict if I have create an query.