Creating a field that does math formula adding previous fields

  • Thread starter Thread starter pointe
  • Start date Start date
P

pointe

I've been tasked with creating an access database to track instructors,
Teaching assistants, and reader/graders. Everything went well until I was
asked to create a query or report that would add up the values for each
Reader/Grader's hours. Currently, each pay period's hours are in a separate
column. Is there a way to add those together? I figured out how to do it in a
form so that they can have it visually, but now they want to run it as a
report, so they can address people who have worked more than their approved
hours. I think, correct me if I'm wrong, I need to have a query, but how do I
createj a field that adds all of the pay period columns for each reader?

Thanks
 
In the form, i used the Control Source with the formula
=[Range_of_Hours]-[TotalHrs1]. What field would I input that formula into
either a Query or Table?
Thanks!
 
Reports have Controls on them just like Forms. You should be able to use
that as the ControlSource for a textbox on your report.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

pointe said:
In the form, i used the Control Source with the formula
=[Range_of_Hours]-[TotalHrs1]. What field would I input that formula into
either a Query or Table?
Thanks!
--
Pt


Roger Carlson said:
How did you do it on the form? That should work on a report as well.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Click to expand...
Click to expand...
 
Thanks!
Is there a way to run a report that will display only records with a
negative number in that field? Assume the field's name will be
[Hours_Remaining].


--
Pt


Roger Carlson said:
Reports have Controls on them just like Forms. You should be able to use
that as the ControlSource for a textbox on your report.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

pointe said:
In the form, i used the Control Source with the formula
=[Range_of_Hours]-[TotalHrs1]. What field would I input that formula into
either a Query or Table?
Thanks!
--
Pt


Roger Carlson said:
How did you do it on the form? That should work on a report as well.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


I've been tasked with creating an access database to track instructors,
Teaching assistants, and reader/graders. Everything went well until I
was
asked to create a query or report that would add up the values for each
Reader/Grader's hours. Currently, each pay period's hours are in a
separate
column. Is there a way to add those together? I figured out how to do
it
in a
form so that they can have it visually, but now they want to run it as
a
report, so they can address people who have worked more than their
approved
hours. I think, correct me if I'm wrong, I need to have a query, but
how
do I
createj a field that adds all of the pay period columns for each
reader?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
I should have phrased my question better: is there a way to do this on the
Query level?

--
Pt


pointe said:
Thanks!
Is there a way to run a report that will display only records with a
negative number in that field? Assume the field's name will be
[Hours_Remaining].


--
Pt


Roger Carlson said:
Reports have Controls on them just like Forms. You should be able to use
that as the ControlSource for a textbox on your report.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

pointe said:
In the form, i used the Control Source with the formula
=[Range_of_Hours]-[TotalHrs1]. What field would I input that formula into
either a Query or Table?
Thanks!
--
Pt


:

How did you do it on the form? That should work on a report as well.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


I've been tasked with creating an access database to track instructors,
Teaching assistants, and reader/graders. Everything went well until I
was
asked to create a query or report that would add up the values for each
Reader/Grader's hours. Currently, each pay period's hours are in a
separate
column. Is there a way to add those together? I figured out how to do
it
in a
form so that they can have it visually, but now they want to run it as
a
report, so they can address people who have worked more than their
approved
hours. I think, correct me if I'm wrong, I need to have a query, but
how
do I
createj a field that adds all of the pay period columns for each
reader?

Thanks
Click to expand...
Click to expand...
Click to expand...
 

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

Using a Table Lookup Field in a Parameter Query 2
Create formula for "Total Hours" field 1
Sum Hours over 24 hours in Access Report 0
Adding Values From Two Numeric Fields 1
Linking tables and adding fields 1
Query - Using SUM in a query where unique dates are present 1
Print a report from a form where you choose parameters 4
Linking Tables and adding fields (second request) 2

Back
Top