help designing my database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.

--
Lynn 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
 
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!
 
Back
Top