Search results

Still can't get it to work. I am still working on my access skills- so I am not very good!

Oh, thanks, will give it a try

What would me be? The form name? Engineering.Priority=engineering!field1 +engineering!field2 ?

First off, I hope to help others in the future on this site...not just have issues! I created a database where I needed to add fields to get the total in another field- field 1 + field 2 = Totals Field (not exact names of fields) I did this in the form which was the only way to get it to...

Finally got the formula to work and it calculates each record! Thanks for all the help!!!

Still not working, I just don't know what I am doing wrong. I put in the formula as you suggested and it gave me an error message.

Ok, I will give that a shot! Thanks:)

On the second part about seperate tables- I had that and a person who was helping me told me to get rid of the extra tables. I do have more categories, but wanted to keep it simple for purposes of the forum

They are suppose to choose one, so that the priority listings stay consistant.

Here it is again....the priorities tab has the formula in it now.

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!

Ok, lets try it now! Thanks

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

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

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

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

Under the totals field in form =Sum([field 1]+[field 2]+[Field 3]+....[field 10])

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)

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...

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!