Form Formula help

[aimless54]

I have been struggling with a data base for a while now, as I am new to the access world.
I have a database to calculate project priorities
Project
Factor 1
Factor 2
Factor 3
Total


I can get all the factors to total, but it calculates one total for ALL records instead of a total in EACH record. I set up the formula in the form as I couldn't get it to work else where!
PLEASE HELP!

 

[rainman89]

Not clear on the question. where do u want the totals to show up?

 

[aimless54]

Not clear on the question. where do u want the totals to show up?

I need it to show up on the form and in the report, but like I said it shows only one total for everything, instead of an individual total. I just can't seem to win!

 

[rainman89]

can you post a zipped version of the db? w/o your sensitive materials?

 

[aimless54]

I cannot as I have certain security settings on my computer which I cannot disable.
Not sure if this will help or not.
I created a totals field where I put the formula to total up about 10 different fields. In each record you are suppose to be able to add in your number between 1-3 and that calculates how high of a priority each project is, but it's doing it as a total for the entire thing, not just the record. I understand if this doesn't help- I can try to send it from home!

 

[rainman89]

What if in the after update of [your number box] you entered
[priority box]= your total calculation

 

[aimless54]

What if in the after update of [your number box] you entered
[priority box]= your total calculation

Can you explain in a little more detail- I am still new to all of this!

Thanks
(trying not to be completely stupid about all this)

 

[rainman89]

can u give me the formula u are using to calculate the totals from the fields?

 

[aimless54]

Under the totals field in form

=Sum([field 1]+[field 2]+[Field 3]+....[field 10])

 

[rainman89]

And that is returning a value for all of the records?

what if u changed them to me.field1 etc...

 

[aimless54]

I am going to try to send it, so you can look for yourself!

 

[aimless54]

Please view attached file, let me know what you come up with - appriciate ALL your help!

 

[rainman89]

its telling me your file is corrupt.... if u will give me a few minutes i will try it on a nother computer in the office

No luck.... perhaps try again?

 

[aimless54]

its telling me your file is corrupt.... if u will give me a few minutes i will try it on a nother computer in the office

Ok, no worries, I had a hard time getting it to post because it exceeded the size limit..I can try again, just let me know

 

[rainman89]

Yeah if you could try again that would be great... was giving me a corruption error

 

[aimless54]

It's too large, can't send it! WIll keep working on it to get it to send. The file is too large

 

[rainman89]

Try compacting and repair then zip

 

[aimless54]

Ok, lets try it now!

Thanks

 

[rainman89]

Got it open, but i do not see the total field that is giving u the problem...

 

[aimless54]

Got it open, but i do not see the total field that is giving u the problem...

Sorry, I had to delete it because of an error- it is the priorities field now. I can send it again with the formula, hold on!