Search results

I'm trying to format a report so that it will come out in print form as a series of individual letters. The table the report is based on consists of one field for the name, several fields for the address and another field for some data text. The same name may appear from one to six times, each...

Ok, now I'm really frustrated. I've spent the last few days restructuring the database and applying the normalization rules. None of it gets me where I need to be. Basically all I need is some kind of query that can do what I can do so easily by eye: work down the records in a table, looking...

I don't need to keep a history of name changes associated with codes from one semester to the next. You are correct that a course code can refer to different courses with different times and locations at different semesters, but during a given semester the name, time and location associated with...

As to requirements: a data enty form which uses the names of students drawn from a large list of students (which has names, but also addresses, etc.) and allows the user to choose a student and then enter the preference number given by that student for each of up to six courses. My form now...

Well, I set up the three tables more or less as you suggested. MemberList (your "tblPeople") has an autonumber primary key (StudentID) followed by names and some other relevant data on the students. CourseData (your "tblCourses") has a CourseID (an autonumber primary key) followed by the...

Ok, I migrated the external table into my database and successfully made and linked the tables as per your suggestion. But now how do I enter the data? I used to use a form which used text boxes linked to fields in the large enrollments table, one text box for each of the course fields and one...

Thanks for the quick reply. Clearly I have some learning to do. It'll take some time. Back later. Oh, one thing, though: the table People is actually outside the database and accessed via a link to the original Excel file. When I tried call the first column a primary key I wasn't allowed to...

I have a table which contains the choices students have made from a list of 40 courses. Each record consists of a student name followed by 40 fields, each designated by a course code. Each of these 40 fields in the record contains either a preference number from 1 to 6 or a blank. I'd like to...

Fantastic! Worked like a charm. I can't thank you enough for the insight.

Sorry I'm unclear on this. The query that the report is based on has (among others) three fields: Name, Draw and Confirmed. So associated with each Name is a Draw number and either a C or a W in the Confirmed field. In the report I sort first by the Confirmed field, which gives me the names...

I have a report which sorts a list of names into two groups based on one field ("confirmed" or "waitlisted"), but I'd like to sort the confirmed names alphabetically by name and the waitlisted names by a different field ("draw number"). I seem to be able to sort the entire list by one key or the...

I originally tried a form, but haven't been able to get it to show a complete list of the students with an entry box next to each on. The best I can do is a combo box that pulls up one student at a time.

I have a report which lists the names of students enrolled in a class based on a query which finds them in a table listing all classes. However I'd like to be able to put an entry box next to the name on the report which allows me to change a datum (for example, GRADE) in the original table...

I'd like to be able to assign a value to a cell in a table by putting a command button on a report and having it place the value in the table when the button is clicked. I can get the macro associated with the button to do various things but not what I want. I've tried Set, but I get an error...

Thanks for the reply. How do I set up a filtered report, though? Where does one put the filter or ask for user input?

Bob, Your dynamic report sounds like exactly what I'm looking for, but I'm too new to Access to understand how your solution works and therefore how to set up one myself. My problem is probably simpler: I am currently generating many individual reports, each based on an individual query where...

Many thanks!! That seems to do it.

I can't seem to sum across the fields in a query. Each row consists of a name followed by ten number fields, and I'd like to get the total of the ten numbers in the row for that name. I've tried using an expression like check:field1+field2+field3..., but the sum is not displayed if any one of...