Newbie Help with variable form entry

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hi

I'm fairly new to Access so all help gratefully received!

I have a table with fields Employee, Normal Hours, Payrate. I have a query
that will give me the average pay amount (Normal Hours * Payrate) and I can
drop this on to a report.

What I am trying to do now is to produce a report that will show the effect
of giving a payrise. I want the form to ask for a payrise percentage and
then produce the report with an additonal two fields showing the effect of
the percentage payrise on the payrate and then also the effect on the
average pay amount. Do I set the input of the percentage as part of the
query or just leave it to the form? How can I do this?

Thanks

Dave
 
One way is to create a new query that is a copy of the already existing one,
and just add a parameter to the calculated field:

Normal Hours * Payrate * ([Enter the percent increase:]/100 + 1)

This query will ask the user to enter the percent number and then will use
it to calculate the revised number.
 
Thanks

Ken Snell said:
One way is to create a new query that is a copy of the already existing
one,
and just add a parameter to the calculated field:

Normal Hours * Payrate * ([Enter the percent increase:]/100 + 1)

This query will ask the user to enter the percent number and then will use
it to calculate the revised number.

--

Ken Snell
<MS ACCESS MVP>

dave said:
Hi

I'm fairly new to Access so all help gratefully received!

I have a table with fields Employee, Normal Hours, Payrate. I have a query
that will give me the average pay amount (Normal Hours * Payrate) and I can
drop this on to a report.

What I am trying to do now is to produce a report that will show the effect
of giving a payrise. I want the form to ask for a payrise percentage and
then produce the report with an additonal two fields showing the effect
of
the percentage payrise on the payrate and then also the effect on the
average pay amount. Do I set the input of the percentage as part of the
query or just leave it to the form? How can I do this?

Thanks

Dave
Click to expand...
Click to expand...
 
Back
Top