Recent content by sfoster1

Figured out how to break out individual numbers Using Left, Mid, and Right statements as given in the examples by both of you, I was able to break the 5 digit/character strings into individual bits. So instead of having a 5 character string for location, I have 5 different location fields...

John... thanks. I shall have to promptly meet with our database administrator and properly tell him off (It was his idea to use this goofy "code" setup in the first place. The problem is that my data comes from the school database (Maintained on proprietary software) over which I have almost...

Need more help with output please. Thanks for your help. My access skills are weak, so please forgive me these next questions. I'm not sure where to place the Function Location. I assume it is still within the query and not in the report. Also, my output is a report for each teacher. It...

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...

It worked PERFECTLY. Thank you.

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 solved it. In case anyone needs to know... here's what I did: I added an unbound text box. I set the control source for the box to the checkbox. Then I changed the format setting to "yes/no" and voila!

Whoops. I meant I want to display "Yes" in a REPORT!

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???

Milo- Why? :confused: Because I was not thinking clearly! Thanks for the nudge (shove?) in the right direction. I am reverting to your suggestion since it is simpler, easier, more efficient, more effective, etc... You would faint if you saw the whole train wreck of my design. When this...

Oops... just got an answer on the Queries thread. I'll try that.

I know I'm not supposed to do this but I'm hoping Pbaldy (Paul) can help. Following on your advice I set up a union select query and it works fine. However, I cannot figure out how to sort my results from the query alphabetically. Here is what I posted on the queries thread for help but got...

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...