Formula in text box on RPT help...

C

Chad

Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
 
K

KARL DEWEY

Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])
 
C

Chad

Karl sorry I answed yes before I checked everything. I also have these
formulas:

=Sum(Abs([Shift]=1)*[EMPLOYEE TIME])
which I changed to:
=Abs(Sum([Supervisor]="Bill Black")*[EMPLOYEE TIME])

and the total is slightly off: I am getting 87.33 hours and the report is
telling me I have 88.00. The first way gives the right total but when I
changed it to the supercisor way it made my hours longer? Thanks!!



KARL DEWEY said:
Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


Chad said:
Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
 
C

Chad

Karl, last one thats not working.
I have this:
=Sum(Abs([Shift]=1)*[FOOTAGE])
and changed to this:
=Abs(Sum([Supervisor]="Chad Zablackas")*[FOOTAGE])

the answer is 903,000 and im getting 927,000

Thanks!



KARL DEWEY said:
Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


Chad said:
Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
 
K

KARL DEWEY

Post your SQL.
--
KARL DEWEY
Build a little - Test a little


Chad said:
Karl, last one thats not working.
I have this:
=Sum(Abs([Shift]=1)*[FOOTAGE])
and changed to this:
=Abs(Sum([Supervisor]="Chad Zablackas")*[FOOTAGE])

the answer is 903,000 and im getting 927,000

Thanks!



KARL DEWEY said:
Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


Chad said:
Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
C

Chad

Karl, How would I post it? Its just a formula in a text box on my report.

KARL DEWEY said:
Post your SQL.
--
KARL DEWEY
Build a little - Test a little


Chad said:
Karl, last one thats not working.
I have this:
=Sum(Abs([Shift]=1)*[FOOTAGE])
and changed to this:
=Abs(Sum([Supervisor]="Chad Zablackas")*[FOOTAGE])

the answer is 903,000 and im getting 927,000

Thanks!



KARL DEWEY said:
Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


:

Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

I was thinking you were using a query.

Try building a query and seeing what results you get there.
--
KARL DEWEY
Build a little - Test a little


Chad said:
Karl, How would I post it? Its just a formula in a text box on my report.

KARL DEWEY said:
Post your SQL.
--
KARL DEWEY
Build a little - Test a little


Chad said:
Karl, last one thats not working.
I have this:
=Sum(Abs([Shift]=1)*[FOOTAGE])
and changed to this:
=Abs(Sum([Supervisor]="Chad Zablackas")*[FOOTAGE])

the answer is 903,000 and im getting 927,000

Thanks!



:

Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


:

Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
C

Chad

I added the query as an expression and the criteria as the supervisors name
and when I run it . It keeps asking for SumOfEMPLOYEE TIME or SumOfFOOTAGE

KARL DEWEY said:
I was thinking you were using a query.

Try building a query and seeing what results you get there.
--
KARL DEWEY
Build a little - Test a little


Chad said:
Karl, How would I post it? Its just a formula in a text box on my report.

KARL DEWEY said:
Post your SQL.
--
KARL DEWEY
Build a little - Test a little


:

Karl, last one thats not working.
I have this:
=Sum(Abs([Shift]=1)*[FOOTAGE])
and changed to this:
=Abs(Sum([Supervisor]="Chad Zablackas")*[FOOTAGE])

the answer is 903,000 and im getting 927,000

Thanks!



:

Try this ---
=Abs(Sum([Supervisor]="Bill Black")*[DT REGULAR])/Abs(Sum([Supervisor]="Bill
Black")*[EMPLOYEE TIME])

--
KARL DEWEY
Build a little - Test a little


:

Hello, I have this formula:

=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])

in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:

=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])

It keeps giving me an error when I change the formula. (ERROR- The
expression you entered contains invalid syntay. You may have entered an
operand without an operator.

What do I need to add to the formula?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
J

John W. Vinson

I added the query as an expression and the criteria as the supervisors name
and when I run it . It keeps asking for SumOfEMPLOYEE TIME or SumOfFOOTAGE
Click to expand...

Please post the SQL of the query.

John W. Vinson [MVP]
 
C

Chad

Everyone, Thanks for the support but I got it fixed! I wanted to use the
formula in a text box on the rpt itself to calculate the totals from each
supervisor. I used:

=Abs(Sum([Supervisor]="supervisors name")*[DT
REGULAR])/Abs(Sum([Supervisor]=" supervisors name ")*[EMPLOYEE TIME])

=Sum(Abs([Supervisor]=" supervisors name ")*[EMPLOYEE TIME])

=Sum(Abs([Supervisor]=" supervisors name ")*[FOOTAGE])


All good....Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with Report formula 6
Abs Formula 4
Formula help for percent 4
Query and text box help on formula 6
Query expression Help 8
Query expression help 11
Percent help 3
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Top