Search results

OK, Ill try that out and get back to you, but from reading what you sugest i know what you mean, and can imagine what it would look like. I am woried that it wont be sutible for what I want to do with the form. P.S. I just now noticed that the title says "forum" and not "form" sorry people!!

Hey, Philip, I've been trying to do what you suggested, make a subform and do it that way. And so heres how it went. I made a new form using the wizard, and added my two queries. I made the one with the rating my subform (and the only field I moved over was the one I needed), and the other...

Yes, thats right, you can run them both seperatly. One thing is tho, that I might have not made clear, is that I am actually adding the calculation quary INTO the origonal, and then trying to put one frield from the calcuation quary into the form. In other words the origonal query already had...

Oh, I see what you were saying. However, the thing is that there are to many other fields involved in the calcualtion so I cant do it on the form I want it to be displayed on. At first i did do all of the calculations on a form (made from the Query(Q1) i later did the math in). The problem...

well, to answere your question, no I dont. The calculations are currently done each year at year end on an excel spreadsheet. But this is alot of work, and so I thought why bother when you could just do it all in access and have it automaticly update it self when we change the ratings (that...

ok, I just did what philipavery said and yes you were right, there was no New Record row. Pat Hartman, I've never used what you mention, but I think that I can think of some problems with that. You see the thing is, I am using a bunch of numbers from other forms in a query that then takes them...

Here is my problem: I created a Query to calculate an over all rateing useing other data that was already in the database. The Query worked out perfectly, and I then wanted to put the one field that gave me the overall rateing that I just calculated and put it into a form. So I added the...