Search results

I know I've seen this problem discussed but can't find it anywhere. I'm trying to query a table and evaluate only one place at a time in a five character coded string, then output descriptive text in a report based on what is found in that place. Each place in the string represents a different...

I am trying to repair the (ugly) data I have had to import to my database. I am working with Access 2000. The problem is this: For many of the records, the data I am receiving (and have no control over) is split into multiple entries because one of the fields was too large to fit into one...

I'm guessing this is really simple. I want to display "Yes" in a report if a checkbox is checked, rather than showing a check. Suggestions please???

How do I sort my union select query results? I have the following union select query: SELECT Counselor FROM Counselors UNION SELECT StaffName FROM tblOtherStaff UNION SELECT CaseMgr FROM tblCaseMgrs UNION SELECT PsychName FROM tblPsychs UNION SELECT SocialWrkr FROM tblSocWrkrs UNION SELECT...

How would I go about having a list box lookup (in a form or table) draw upon more than one table? In other words, I want to be able to have the user, when entering data in a form, select a name from one of two different tables for one of the fields. Guessing a query would be the way to go here???

Trying to determine if I am going about this right. I have two primary questions: 1) Should I be using Linked Forms or should I be using Forms with Subforms?; 2) What is the best way to stay with a particular record as I move from form to form. Let's say I have four tables: tblStudents...

First of all, the more I read here, the more I realize I'm in over my head. Also, I see I've violated many db conventions. I need to learn db and Access from the ground up. Any suggestions on how to do that? More immediately, I am a school teacher volunteering to build a database for our...

I have a database of students, instructors, and classes. I set up a form for teachers to give regular feedback on student progress I am able to set up a form with drop-down lists where the instructor can select themself, their course, and their student. HERE IS MY PROBLEM: I need to have each...