help designing my database

[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!

 

[tina]

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

 

[Lynn Trapp]

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

 

[Guest]

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!