Please for Help
From: gjoko_at_mt.net.mk ((gjoko_at_mt.net.mk))
Date: 05/23/04
- Next message: Retna: "configure multiple instance in enterprise manager"
- Previous message: Vishal Parkar: "Re: NOT IN More Efficient???"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 May 2004 02:29:47 -0700
Please for HELP
In first step I sorry for my bad English, but I hope that you will understand me. I use MSAccess DB and have some problems with my queries.
I created two tables. In first I put fields: Name (text); Account (curr.); Mark (curr.); ACC_account (curr.); and ACC_Mark (curr.)
In second table I created fields: Account (curr.); Limit (curr.); Rate (curr.); and Ident (number).
In created query I must acquire result (new field, or old ACC_Account) between fields Account and Mark multiply with 0.0015 (this percent is different for different Name) or 0.001 or 0.0014 where
Condition is height by Account. For example, for Name1 agreement for Account by 500000 is
0.0015 percent, but if account go > 500000 then percent is 0.001; in case 2 when Name2 have account <650000 then percent is 0.0015, but when account is >650000 then percent is 0.001;
in case 3 when Name3 have account between 0 and 10.000.000 then percent is 0.0014; and
case 4 in permanent case or Name4 have account between 0 and 10.000.000 percent is 0.0015.
In same time I must to acquire result in field ACC_Mark where ({Account]*[Mark])*(0.0015)+
[Account]*[Mark]/([Account]).
I hope that you understanding, and if you know please answer to me how I can solve this problem. Does I created query or best for me is writing the code (Module)?
Gjoko,
Thank You
**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
- Next message: Retna: "configure multiple instance in enterprise manager"
- Previous message: Vishal Parkar: "Re: NOT IN More Efficient???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
