Converting single record formulas to multi record formulas and report writing

[beech10b]

First of all, I would like to point out the fact that I don't know anything so please go easy on me. Ok, I'm currently working on my second database for my company. The first one was somewhat successful but inefficient and not user friendly. In fact, I'm the only one who can use the database...not cool. Here is the problem: I have series of complex formulas in VBA (Forms), mostly depending on two tables, a few queries and each other. The Form works: I can select an item, click compute and get results but that's not good enough for the company. The need to compute all records at one time and be able to flip through records. Also, they want to be able to run reports based on the calculations. I don't even know where to start. My initial thought was to put all the formulas in the tables but that hasn't worked out very well for me. Please advise. I can post the code on here but it will probably take up several pages simply because I didn't know what I was doing. Any help would be appreciated. My email address is alfred.k.daniels@gmail.com Thanks.

 

[trevil620]

One simple solution to me seems to be to create a FUNCTION that returns the calculated value, then create your query and use the FUNCTION output as one of the columns. For example your data has PRICE, UNITS, DISCOUNT; Have function calculate UNITS * PRICE * DISCOUNT and return INVOICEAMOUNT.

Sometimes computer problems are like genealogy... The answer to one problem leads to two more!