Placing the results within a table

[Guest]

I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not able to
transfer that total into my table.

My code for this text box is

=[VacancyQty1]+[VacancyQty2]+[VacancyQty3]+[VacancyQty4]+[VacancyQty5]+[VacancyQty6]

it adds up the number from each of those fields. What I wanna do it to get
that sum placed into my table. I have tried

[TotalVacancy]=....
"TotalVacancy"=...
="TotalVacancy"....

Please help me. I am at a lost.
Please and Thank you,
Hillary

 

[Steve]

It is not correct to put the total in your table! You can display the total
anytime in a form or report by oputting your formula in the controlsource
property of an unbound textbox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Is there any possible way to do it at all though? I want to be able to sum up
how many total available openings that each school has and show it on my
table. I'd rather have it in my table then a report.

Another totally different question....When I create a query does it automa.
update itself if the main table is updated to fit the criteria of the query?
for instace, In my main table i have a status for each one of my candidate -
Hired or Not Hired. In my query I have it to where it should show all the
persons that are the status=hired. But as time goes on I will change (update)
the status of some to equal to "Hired" and wish for that person to show up in
my query. This should be possible right?

Thanks a bunch! ~Hillary

It is not correct to put the total in your table! You can display the total
anytime in a form or report by oputting your formula in the controlsource
property of an unbound textbox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not able
to
transfer that total into my table.

My code for this text box is

=[VacancyQty1]+[VacancyQty2]+[VacancyQty3]+[VacancyQty4]+[VacancyQty5]+[VacancyQty6]

it adds up the number from each of those fields. What I wanna do it to get
that sum placed into my table. I have tried

[TotalVacancy]=....
"TotalVacancy"=...
="TotalVacancy"....

Please help me. I am at a lost.
Please and Thank you,
Hillary

 

[Steve]

<< I'd rather have it in my table then a report.>>

No one should EVER be looking at the tables!! You look at your data through
forms and reports. Putting a total in your table is just the wrong thing to
do!!

Part 2 .....
Once again, no one should EVER be looking at the tables!! If you have a form
that displays the data from the query and the criteria is "Hired" for the
Status field, you will get a list of hored employees.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Is there any possible way to do it at all though? I want to be able to sum
up
how many total available openings that each school has and show it on my
table. I'd rather have it in my table then a report.

Another totally different question....When I create a query does it
automa.
update itself if the main table is updated to fit the criteria of the
query?
for instace, In my main table i have a status for each one of my
candidate -
Hired or Not Hired. In my query I have it to where it should show all the
persons that are the status=hired. But as time goes on I will change
(update)
the status of some to equal to "Hired" and wish for that person to show up
in
my query. This should be possible right?

Thanks a bunch! ~Hillary

It is not correct to put the total in your table! You can display the
total
anytime in a form or report by oputting your formula in the controlsource
property of an unbound textbox.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not
able
to
transfer that total into my table.

My code for this text box is

=[VacancyQty1]+[VacancyQty2]+[VacancyQty3]+[VacancyQty4]+[VacancyQty5]+[VacancyQty6]

it adds up the number from each of those fields. What I wanna do it to
get
that sum placed into my table. I have tried

[TotalVacancy]=....
"TotalVacancy"=...
="TotalVacancy"....

Please help me. I am at a lost.
Please and Thank you,
Hillary