Rabbit
For 'no entry list' I meant tBuys has no record corresponding to specific entry in [tBuy Invoice].
Thanks for your reply.
AbbasBD
Last Activity: Aug 3 '12, 04:22 PM
Joined: Aug 11 '10
Location: Dhaka, Bangladesh
-
twinnyfo
exact solution!
thanksLeave a comment:
-
Delete query cannot find required entry
I want to delete entry in table [tBuy Invoice] where linked table [tBuys] has no record. Statement is -
-----------
DELETE [tBuy Invoice].*
FROM [tBuy Invoice]
WHERE ((([tBuy Invoice].BuyInvcID)
In (
SELECT [tBuys].[BuyInvcID]
FROM [tBuys]
WHERE [tBuys].[BuyID] Is Null
)));
-------------
But the Delete query do not find any entry. I think it is because 'Is Null' do not... -
NeoPa
Thanks for your observation. I'll be careful... next time. However, correct one should be:
If BS<=5000, HR=BS*50% but not less than 2250,
Stay fine.Leave a comment:
-
@Jerry Maiapu
Yes right you are! 1, 2, 3, 4, 5 are not constant.
I want to find expression for Personal Basic [PB] that will be equal or greater than New Basic Min [NBM] by adding Increments [IR] to Basic Start [BS] (Here, always BS<NBM).
If [NBM]>=[BS]+1*[IR], its OK, but if by adding one IR doesn't make it, than should add two IR, ie, [NBM]>=[BS]+2*[IR]... Here, IR is incremental, may be nine IR...Leave a comment:
-
Dear Maiapu
I failed to apply iif function, i've no idea about 2n+1 sequence formula... however, i tried the following that didn't work:
PB:
IIf([NBM]>=(1*[IR])+[BS],(1*[IR])+[BS],
IIf([NBM]>=(2*[IR])+[BS],(2*[IR])+[BS],
IIf([NBM]>=(3*[IR])+[BS],(3*[IR])+[BS],
IIf([NBM]>=(4*[IR])+[BS],(4*[IR])+[BS],
IIf([NBM]>=(5*[IR])+[BS],(5*[IR])+[BS]
)))))
Sure i've something...Leave a comment:
-
Jerry Maiapu
Thanks for your concern. Sorry for not being able to make you understand... however, just few hours back i’ve found out a solution that works for me:
PB:
(((([NBM]-[BS])\[IR])+1)*[IR])+[BS]
However, i welcome you, should you have anything better.
Thanks.Leave a comment:
-
I want to build an expression in MS Access Design View for ‘Personal Basic’ [PB] where [PB] is equal or immediate greater than ‘New Basic Minimum’ [NBM] by adding one or more ‘Increment Rate’ [IR] to ‘Basic Start’ [BS] ie,
[PB]=[BS]+([IR]*x) {where [BS]+([IR]*x)>=[NBM]}
For example:
[PB]=4500+(240*2) {here [NBM]=4890<4500+(240 *2) ie, x=2 but Not x=1 or x=3}...Leave a comment:
-
dear jerry
thank u very much for your prompt reply, it worked greatly!
AbbasBDLeave a comment:
-
Sorry, my knowledge is quite basic, I want to build expression for HR in design view something like:
HR:
IIf([BS]<=5000,[BS]*0.5,But if[BS]*0.5<2250,"2250 ",
IIf([BS]>5000 And [BS]<=10800,[BS]*0.45,But if[BS]*0.45<2500,"250 0",
IIf([BS]>10800 And [BS]<=21600,[BS]*0.4,But if[BS]*0.4<4800,"4800 ")))
Here, I do not know what may be correct expression for...Leave a comment:
-
building an expression in ms access
I want to build an expression for House Rent (HR) in MS Access.
If Basic Salary (BS) is =>5000, HR is 50% of BS but not less than 2250,
if BS is between 5001 and 10800, HR is 45% of BS but not less than 2500 and
if BS is between 10801 and 21600, HR is 40% of BS but not less than 4800
No activity results to display
Leave a comment: