Invoicing and customer database

Discussion in 'Access' started by Knh2r, Jul 6, 2016.

  1. Knh2r


    Jul 6, 2016
    Likes Received:
    Hey guys. I'm trying to build an invoicing and customer database for my small sheet metal business. I don't need inventory functions. Any ideas of basic templates to get me started? I used to be fairly literate in this stuff but it's been a while.

    Also. One of my main issues is that I need items priced on the invoice based on a "multiplier" from a table and the size (2W x 2H x L Factor). That's what's really stumping me at this point.

    Example. I input item #. It looks that up and inserts item from list. Then asks for H, W, and L. The L is linked from a "factor table" based on the length I input. So maybe 10" is .23 in the price formula.
    Any help us greatly appreciated!
    Last edited: Jul 6, 2016
    Knh2r, Jul 6, 2016
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.