Search results for query: *

I have 4 columns of data in the same table (Min, Mid,Max, Salary). I am trying to create a chart that plots these 4 on the SAME line going horizontally across so basically it would look like a line with four different "X" marks. The value also needs to display. Example below - note that the...

I put in exactly what you have. Not working still. I get the same error message as before. To create this formula I created a new field from the field list. Perhaps my table links that I created when I chose my data source is the problem? I appreciate the help, I can't think of what else...

That field is a string field - it had a [25] which I assume is the field size. It has values in it of 1,2,3,4,5 "Fast", "Slow", and "N/A".

I created the field, put it into the details section to test and got the following information dialog box (the only button this box gave me was the "OK" button to acknowledge the message below: "A number, currency amount, boolean, date, time, date-time, or string is expected here." It let me...

I used your code but didn't get it to work. if isnumber({STUDENTEVALS.EVAL_ANSWER}) then val({STUDENTEVALS.EVAL_ANSWER}) else 0

Thank you. I have Crystal 8.5 and it is a Sybase Database I am connecting to.

Issue: I am trying to create an Average field (in the group footer)for a field called "Evaluation Scores" (which is in the Detail section). Problem: The field is a String type (the choices on the eval are 1,2,3,4,5 and "N/A" - the evil string part) so I cannot run any summary operations on it...

That makes sense. I think discussing this has helped clarify some things for me. The reason I had the same course listed multiple times in the Courses table (even w/o the Levels field) is because I have distinct description, length, prerequisites, etc. for each individual course. Given what...

Thanks. I did separate the skill levels into a separate table already (which solved one issue) but still did not solve the issue of pulling in the CourseName field from the Courses table into the Classes form and displaying each CourseName distinctly in the dropdown.

I did try the DISTINCT option as well, but then I had to change the ColumnCount and ColumnWidth to display only one column (CourseName) but then whatever I choose in the dropdown arrow ("Typing" for example, is entered into every class for every record - it doesn't just choose "Typing" for that...

Yes, I think you understand my predicament. Each CourseID is different. Ex: For the course "Typing Intro" the Course ID is 1, for the course "Typing Intermediate" theh Course ID is 2. I have done distinct rows using a field from the current form (current underlying table), but never a field...

Hello, I have a "Courses" table and a "Classes" table (1 to many relationship - 1 Course = many Classes). The problem is in my "Classes" Form. I want the "CourseName" field from the "Courses" table as a DISTINCT dropdown box inside my "Classes" form. Example: If I offer a course in...

Hi Eupher, I put in the two lines just as you typed them. The first line in the OnClick event of the cmd button on the 1st Form and the second line of code in the OnOpen Event of the 2nd Form. I got an error for the 2nd line of code. Here is the line it highlighted: Me!ModelID = Me.OpenArgs

Okay - I think I get the second line of code, but where do I put the first line (the "DoCmd.OpenForm...")? Is this attached to an event or just write it in VBA. (VBA is not my strong suit yet).

Where do I type this? In the macro or in the field itself (which property of the field if it is the field?)? The 2nd form is supposed to open on the click so it is supposed to be opened and populate together.

I have the same "ID" field in my 1st form and my 2nd form. When I click on a cmd button to go to the 2nd Form, the "ID" field on the 2nd form needs to automatically populate itself with the same "ID" that was in the 1st form. Example: "ModelID" in the "Models" table (the 1st table) equals "10"...

One other thing to be aware of. My "Evaluations" form is a main form with a subform as well, so when I click to go to the "Evaluations" form, it will show me the Evaluation type and then in the subform show me everyone's eval scores so every eval in theory will be tied to that ClassID field. I...

I have a "Class" form with a field on it called "ClassID" and a cmdbutton on the same form named "Evaluations". When I click on the "Evaluations" button, I need it to take me to the "Evaluations" form (that part is working). I also have the "ClassID" field on the "Evaluations" form and I need...

Here is the code that is in the "On Load" property of the second form (EvaluationType): [Forms]![EvaluationType]![ClassID]=[Forms]![Classes]![ClassID]

I did that - when I go to open the 2nd form now, it gives me an error message: Access can't find the Macro 'Forms!...and the rest of the phrase for the code