 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005help designing my database
any ideas, suggestions would greatly appreciated! I am trying to create a database that capture increase/decrease in invoice Amount weekly. I download the file from company's intranet containing invoice #, invoice date, invoice Amount and Customer name. (we are using Oracle system). What I am currently doing is that first Monday of the month, I download the file and import it into "Week 1" table. 2nd Week, i download it and import into " week 2" table and so on. (there are up to week 5 table because some months may contain 5 weeks). Then I do simple calculation to see if there were increase or decrease from week 1 from week 2, week 3 and so on. Is there anyway to simplify this process? Thank you! what part of the process are you hoping to simplify? standard normalization rules dictate one table, not five - with an additional field in the table to designate what week each record belongs to. but you're doing what i call "quick-and-dirty" manipulation of data from an outside source. i can see where the five separate tables might make for easier calculations in a query, assuming you can link each of the tables on a common field (invoice number?). so again, if your calculations are simple to set up, and accurate - what part of the process do you want to simplify? i'm not trying to discourage you, but we need more details before anyone can offer suggestions. hth > any ideas, suggestions would greatly appreciated! > [quoted text clipped - 9 lines] > there anyway to simplify this process? > Thank you! PMFJI. My friend, tina, is going to help you out very well, but I have one question. Does your company use Oracle Applications or do you simply have your own system built on an Oracle database? The reason that I ask is that there is probably a seeded report in Oracle Apps to do what you want to do.  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html > any ideas, suggestions would greatly appreciated! > [quoted text clipped - 12 lines] > there anyway to simplify this process? > Thank you! Thank you both for the help. We are using Oracle Application, there is not a report for what i want to do. :-( . I apologize for not giving more information, i was thinking about it, but just didn't type it. :-) While i was looking and working on it yesterday, I realized most of my concerns were not the design but the automations. This discussion group probably isn't the right place since it concerns queries so I will not waste any more of your time. Sorry about that! I think I just had a panic attack! :-) Thank you both for your support! > PMFJI. My friend, tina, is going to help you out very well, but I have one > question. Does your company use Oracle Applications or do you simply have [quoted text clipped - 17 lines] > > there anyway to simplify this process? > > Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.