Hi Fred,
First Thanks for replay,
I will try your suggestion and something came on my mind. I was thinking to
make combo box with years on start up form. if I'm correct in all my query I
need to make extra criteria same thing like : [forms]![StartUp].[cmbYear]
Yes or No ?

-----Original Message-----
From: fred kampf [mailto:kampf369@y...]
Sent: Monday October 2002 13:41
To: Nikola
Subject: Re: History table


I had a little trouble following you but from what I
gather, you need to keep more than one years budget
information.

What I ended up doing is to keep all of my data in one
table (even though I have more than one years worth of
data)

You just set up your queries to only pull the year you
want - For example, if you were pulling the 2002
budget you would insert the criteria under date of
"between 1/1/02 and 12/31/02.

That should work fine for you.

Fred

--- Nikola <Nikola@b...> wrote:
> Hi, I have same proble now like you before 1 year.
>
> In my Db i have  table Budget and Orders.
> table Budget have field:
> BudgetID = VesselID & AccCodeID
> VesselID,AccCodeID,From,To,DailyBudget
> Form of Budget is in Datasheet format and have next
> field :
> Vessel,AccCode,From ,To,DailyB,YearlyB.
> YearlyB = ([To]-[From] + 1)*DailyB
> So user can see what is yearly budget for accCode
> for that Vessel and form
> look like:
>
> Vessel    AccCode    From        To          Daily
> B.    Yearly B.
> Nicola D     3310    01/01/02    31/12/02     12.00$
>     4380.00$
> Nicola D     3311    01/01/02    31/12/02     12.00$
>     4380.00$
> Nicola D     3312    01/01/02    31/12/02     12.00$
>     4380.00$
> In footer of Budget form  i have unbound field where
> sum all Yearly Budget
> of code's and on that way i have Yearly Budget for
> 2002 for vessel Nicola D.
> I another form (Orders) i have field's Cost, date
> ,AccCode,Order No,Vessel
> Name.So when user enter Cost,AccCode,Order No and
> Vessel,  table for order
> look like this :
>
> vessel    AccCode    Date        Order No    Cost
> Nicola D    3310     10/01/02    NID02D/02
> 500.00$
> Nicola D    3311     23/03/02    NID16E/02
> 800.00$
> Nicola D    3312     15/05/02    NID63E/02
> 1000.00$
> I create query that from Budget for Vessel Nicola D
> or same another vessel
> subtract cost from Order form.
> all this is working OK.But now my boss want to keep
> in working DB orders and
> Budget for working year and year before.So i think I
> need samehting like
> History table for orders and for Budget. Let say in
> 2003 i gone create new
> Budget table so where to put budget from
> 2002,becouse budget from 2002 mast
> be separate from budget for 2003,and orders for 2002
> same.
>
> So if you have any exsample of db or code please
> send me .
>
> Thanks
>


__________________________________________________
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/