Search results
-
A
Form Formula help
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... -
A
Query Formula
They are inputing the information in a seperate form, but I was told that the formula itself should go under the query. I have tried it several different ways and nothing seems to do the trick! Will give what you wrote a try and see -
A
Query Formula
Ok, thanks, I will give that a try and see what happens! -
A
Query Formula
Just two tables- one that is important, the second doesn't really pertain its for other information. Since I am new at this- I just want to make sure I am creating the formula in the right place- under Query, Design View...under the priority field typing the formula under criteria? -
A
Query Formula
Locks up the cells so you cannot input #'s...I am missing something from the equation-- literally! -
A
Query Formula
I am new to the access database world- I have a database in which I have projects that each have a priority- to get the priority # there are about 10 categories that need to total up to give me that priority # Every formula I have tried, has given me an error message of some sort! PLEASE HELP...