Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Building an access database


(!)

blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
26-Apr-2012, 03:01 PM #46
No, I do not need to store the Discount information each person discount is suppose to be base on the amount of year of service multiply by two 2% (BSOSplit%) but there are different cases.
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
26-Apr-2012, 03:27 PM #47
I'm sorry I do need to store the discount information I was reading the post incorrectly. LOl (at my self)
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
26-Apr-2012, 03:38 PM #48
Discount is working also.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 07:36 AM #49
Can you work out the retireeAmount now?
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
27-Apr-2012, 08:16 AM #50
No, still have issue with it.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 12:36 PM #51
Try
me.RetireeAmount =me.[Premium]-(me.[Premium]*me.[Discount])
Although if you put it after the previous vba code you should be able to use
me.RetireeAmount =me.[Premium]-me.[BSO Amount]
because the [BSO Amount] should now be in place.
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
27-Apr-2012, 01:18 PM #52
I tired both and none did the trick.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 01:43 PM #53
What is happening?
Are you sure about the Field names?
Have you removed the Calculation from the Control Source?
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
27-Apr-2012, 02:07 PM #54
The Field names is correct. I try removing the calculation in control source it did not work at all. I attached a zip file on all I have done please take a look, there is two dummy input.
Attached Files
File Type: zip Retiree.zip (75.6 KB, 3 views)
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 02:17 PM #55
Your RetireeAmount Field is actually called "2012 RetireeAmount".
I have added the adjusted VBA code to both Premium and Discount fields and it is now working.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
27-Apr-2012, 02:18 PM #56
Here is the updated version.
Attached Files
File Type: zip Retiree (1).zip (73.6 KB, 2 views)
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
27-Apr-2012, 03:03 PM #57
It did work.
Would the same concept work for (BSO Retiree split %)? I keep changing the way I input the formula I'm still getting the funky result.

And if I did the same thing I did with Departments field to the plan and premium field will it work also?
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
27-Apr-2012, 03:37 PM #58
After speaking to someone in my department I am thinking off omitting the RetireeSplit%, she will be giving me that part of information and that calculation will be done by her for now.
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,610 posts.
 
Join Date: Mar 2005
Location: UK
28-Apr-2012, 07:01 AM #59
The VBA code can be made to work for the RetireeSplit% if you want, it is up to you.
blessnhappy's Avatar
blessnhappy blessnhappy is offline
Member with 69 posts.
THREAD STARTER
 
Join Date: Apr 2012
30-Apr-2012, 08:48 AM #60
Sorry for the late reply, I have been study for my biology finals.
If I can make the RetireeSplit% work I will have a go at it.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑