Search results

I tried both ways and Fitz's way seemed to take... I kept getting an error stating that the data member couldn't be found or some such nonsense but when I used the same "member name" on fitz's suggestion it worked... I'm assuming there is something ary with my report name, being referred to as...

Hi All, I'm probably missing something really simple here but I can't seem to figure this out. I have the following code that takes place on the form frmmaster1. I want to open the form Trends and close frmmaster1 if the answer to the box is yes. It works to open trends but it seems every...

The query already displays the counted values though so would DCount be right? It matters more WHO is at 5... The query is set up like the following Supervisor Name #of evals completed for today Basically it uses the main table to count the number of scores that were recorded on that day and...

Hi Everyone, I have 7 or so analysts who "score" or evaluate a group of 200 people. Those 200 people are each assigned to a Supervisor. Each of these 200 people recieve multiple evaluations in a month; some recieve 5, some 8, etc. So the table is set up with Employee Name, Supervisor...

Hi Everyone!, I have a report that includes a list of names and some detail (scores) for each name. I would like to be able to double click on the name and have the report filter out only this name. For example, John Jenny James <double click on James> James I'm hoping there is some simple...

Hi guys, I tried narang's solution and that did it. Instead of having two columns (one for ID and one for Name), I now have one column that records the numerical ID but shows the analyst name per the look up.. On the master table, the Analyst column has a numerical input, (1,2,3). I completed...

Hi All!, I have a tricky one... or hopefully perhaps very simple. I have have a "master table" with Analyst ID and Analyst fields among other fields needed. Analyst ID is a number and Analyst will be the name of someone that corresponds to that number. I have a separate table that defines...

Thank you very much for your reply and code!!!! Putting it on the form was actually prefered for me as long as there is an all option. Although very very new at this I usually pick up on the logic behind the code pretty quickly... this one is definately going to take some researching There...

Hi Guys, I have uploaded my database here. I have everything set up exactly how I want it except ONE thing. There is a report card report that is opened by a report card filter form. The report is filtered by a query. I want the user to be able to filter the report card by what's already on the...

Hi All!, I have a form that comes from one main table. The form will be used to make a class roster. There are choices of Trainer, Class Name, and Start Date. The only other thing on the main form is a text box for the New employee name. The user then clicks add student and the new "list" is...

I figured it out based on some logic I've learned from you in previous posts :). I created the form from the table with the fields I needed (trainer, class name, start date, employee name). I then created a new query with the same fields. On the query, the Trainer, Classname, and start...

Hi All, I have a pretty simple db that currently has one main data table with things like Employee name, class, class date, scores, etc. I am trying to make a form where my trainers can add a new "roster" of people when a new class starts. (These will record to the main table and then the...

That would make sense!! I fixed it by putting >=.945 and did that for the rest of them to... whew. Thanks so much for your help! I will be using this simplified formula for the others as well :)

Thanks for the response pbaldy! It's closer haha but scores of 95% are still showing just successful instead of 'exceptional'. I've attached the updated... I even tried changing .95 to .949999 to see if that helped.. no dice.

Hi All, I have a report that does some calculations based off of one very simple table. Basically I have a few collections of scored based off of quizes and tests; some are averages and some are there to display just the one score. I then have two text boxes underneath programmed with some IIF...

Thanks again! 3 for 3?

Alright guys, I have used this formula on many of the text boxes in my report, tweaking the values and text boxes of course. There is one box, the weekly quiz text box that I can NOT get to display properly. The box is an average and i've checked to make sure it is calculating correctly, it...

Your code worked PR2... thanks very much!!!! :rolleyes:

pr2... I did try that but I'm thinking the syntax might have been wrong.. I will try that option!!! currently all of my previous fields have changed to #Name for some reason so I guess I have to figure that out first.. I'll let you know how it goes!

I was hoping to not have to add unncessary tables but that is definately a viable suggestion! My only issue is that I have to do this for multiple boxes and each definition is different... I will try it though as it seems to be the most simple way of doing it! Thanks for the help!