expression i need to write rate -admin costs*driver percentage in.

dasad wrote:
I just finished jumping up and down and shouting for joy. IT WORKS! IT
WORKS! IT WORKS!.

Thank you so much for all your time and effort. You don't know how much I
appreciate it. I had just got to the point where I was going to give and try
and figure a long way of doing it. Thank you Thank you thank you.
"Andreas" wrote:


Well, that is great news, but I am still befuddled as to
what was causing the problem?

--
Marsh
MVP [MS Access]

I did what Andreas told me to do and it worked but I do not have the
understanding of what i did at this time. SO basically I am also befuddled
but maybe Andreas can tell you what the problem might have been.

"Marshall Barton" wrote:

dasad wrote:
I just finished jumping up and down and shouting for joy. IT WORKS! IT
WORKS! IT WORKS!.

Thank you so much for all your time and effort. You don't know how much I
appreciate it. I had just got to the point where I was going to give and try
and figure a long way of doing it. Thank you Thank you thank you.
"Andreas" wrote:


Well, that is great news, but I am still befuddled as to
what was causing the problem?

--
Marsh
MVP [MS Access]

Great!

Ideally, you should now work backwards and figure out exactly what
stopped it from working in the first place.
Then, you will hopefully never have that problem again, as you won't
make the same mistake again. :-)

Regards,
Andreas


dasad wrote:
I just finished jumping up and down and shouting for joy. IT WORKS! IT
WORKS! IT WORKS!.

Thank you so much for all your time and effort. You don't know how much I
appreciate it. I had just got to the point where I was going to give and try
and figure a long way of doing it. Thank you Thank you thank you.
"Andreas" wrote:


Now add the following columns to the query:
AdminRate: DriversRate * AdminPercent / 100
DriversPayment: (DriversRate - AdminRate) * DriverPercent / 100

Regards,
Andreas


dasad wrote:

I did get the correct results from the query you told me to run. SO the data
is not the problem. Do I need to rename my "rate " column? would that help?

"Andreas" wrote:



- Create a new query in design view
- Add the table as your datasource
- Create the following calculated columns:
DriversRate: Format([Rate],"#,##0.00")
AdminPercent: Format([Admin Costs],"#,##0.00")
DriverPercent: Format([Driver Percentage],"#,##0.00")
- Run the query and check the result of your output
- For your example, you should now have the result:
100 5 25
If not, then the problem is with the data.

Regards,
Andreas


dasad wrote:


i did a cut and paste and took your formula and pasted in the query under
design mode. I still comeup with the same 25.00

"Marshall Barton" wrote:




It gives me the right answer. Are you sure Admin Costs is
spelled correctly or has a value of 5?

I doubt that this is the problem, but you should be aware
the Rate is the name of a built-in function.
--
Marsh
MVP [MS Access]


dasad wrote:



I did try your original suggestion and I stil get 25.00 not 23.75

"Marshall Barton" wrote:



Please try my original suggestion:

Driver Pay:
Rate* (1 - [Admin Costs]/100) * ([driver percentage]/100)

and let me know what results you get.


dasad wrote:



Driver Pay: [rate]*[driver percentage]/100
this is the expression I am currently using. I need to add in the admin
costs. I have "cut and paste" all the formulas you both have given me and it
still leaves out the admin costs. Instead of 23.75, I get 25.00.


"Marshall Barton" wrote:



How about that, my original guess was the right one ;-)

Now let's go back and try the expression I posted earlier
and see if we can figure out what about it, or your data,
leads you to think "it doesn't work".

Do you have a data record with a Rate of 100, Admin of 5 and
Dirver 25? Try it and see what result you get, it should be
23.75. If not, pleas post back with the result you did get
along with a Copy/Paste of the **exact** expression you're
using.

Check Andreas posts too. We are both suggesting equivalent
expressions that will produce the same results. He also
makes a good point about using names with spaces or other
funky characters.

I'd love to have a closer look myself but since I don't have Access on
this PC it is a major pain ...

Looks like a job for ... you :-)

Regards,
Andreas


dasad wrote:
I did what Andreas told me to do and it worked but I do not have the
understanding of what i did at this time. SO basically I am also befuddled
but maybe Andreas can tell you what the problem might have been.

"Marshall Barton" wrote:


dasad wrote:

I just finished jumping up and down and shouting for joy. IT WORKS! IT
WORKS! IT WORKS!.

Thank you so much for all your time and effort. You don't know how much I
appreciate it. I had just got to the point where I was going to give and try
and figure a long way of doing it. Thank you Thank you thank you.
"Andreas" wrote:


Well, that is great news, but I am still befuddled as to
what was causing the problem?

--
Marsh
MVP [MS Access]