RE: Formula Calculation Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Fred,

Thanks for responding back. This database that I am trying to get going is a
bit confusing I appologize for not giving the detail, but I didn't want to
drop off a book on the first post and was trying to make it as simple as I
could. Lets say this is for a auction. I have five items that have already
set todays prices. I need to move them from the auction to wharehouse. I
have to figure in the cost to move it, or how high will I pay freight per
mile to get it there. I then need to know at the highest price I can buy it
at, which includes the frieght. Once it gets to the wharehouse, there is a
discount on the rating of the product. Which I figured in with my highest
buying price (estimate). Now my offset on my purchase price helped with the
discount being right on or slightly off. Thats why I was explaining first
form, second form and third form on my original post. My third form is
giving me the buying price. Each of the five items are being put on display
one at a time with seconds in between. Thats why I don't need to store the
todays prices, freight cost, or highest price, buying price and discount
until I actually bought that one product for each sale. Then I need my report
to show todays sales, which load had what, total weight on truck, Avg weight,
Avg Rate, Avg Discount, total items and so on. I guess what i am asking is
Can I use Temporary Tables in Access? Meaning, tables that have no relations
to each other, but to hold all figures until actual sale. Something like a
calculator done in access. Now I was thinking I could use one query to clear
the temp tables, or one query to update the main tables. As for my five
textboxes on the first form, I am thinking I might have to do some type of an
array to pass into a combo box, but I will step over to programming or form
side of these discussions to ask that when I am ready. I hope I wasn't too
confusing, on how this database is going to be, but I don't need to know the
penny savings, rather the quarter penny savings.
.

Relevant Pages

  • Re: How do I add iserr or iserror to this
    ... If you have no data in Discount or Price, ... If you blank out a value in Discount or Price using the space bar, ... Provided you have NUMERIC values or a genuine blank cell in Price and Discount, you will ALWAYS get an answer in Result. ...
    (microsoft.public.excel.programming)
  • Re: The Power of the Potter (no spoilers)
    ... that doesn't necessarily imply that the publisher and the author are ... cover price for high discount sales. ... fare less well because even with discount theydon't always sell enough ...
    (rec.arts.sf.composition)
  • Re: How much Do You Spend On Smart Drugs Per Year???
    ... It would give me a 25% discount on piracetam and I don't remember what ... The 25% discount would apply to them as well. ... tell UN what you want and take the price they offer you. ... Do you get PappaNature's quantity discount towards shipping? ...
    (rec.drugs.smart)
  • Re: Vegas Vacation Advice
    ... I'm not much of a gambler; didn't play at all first time out. ... I do prefer to pre-purchase tickets at discount through www.goldstar.com. ... Their prices aren't quite as good as the 1/2 price places but they are already purchased and I don't have to stand in line the morning of the show. ...
    (alt.vacation.las-vegas)
  • Re: Harley Points
    ... profit margin which probably does work out to 10% of the price. ... If we lose the discount at HD it just might ... trigger my entirely irrational purchasing patterns by boycotting the ... Bonus for me too. ...
    (rec.motorcycles)