Recent content by nmartineza

The unit data is located in "tbl_Clients" and the field name is "Program." At this point I have come down to the same conclusion and have decided to move the field "Program" to "tbl_Incidents" since our clients move through units consistently and this seems to be the best way to keep that...

I have attached a screenshot for the only relationship established between my two tables. In this screenshot you will be able to see all of the objects I created.

I apologize for the misunderstanding. I think I misunderstood the task that you gave me. Those names shown in the screenshot are unfamiliar to me as well. How would I go about showing you the relationships you need to see? Thank you!

and this is post 10, I should be able to post my URL on the next one :(

And I guess I have to wait at least 60 seconds...

I guess I just have to post more... this is post 8

When I try to post the URL for my picture, there is a message that says I need to have 10 or more posts and that I currently have 6. I don't even know what that means...

I work at a mental/behavioral health facility and I use Microsoft Access to collect information on incidents regarding our adolescent clients. The database is really basic, I have one table that stores client information, one table that stores the incident information, a query that links both...

:D! It definitely is!

Paul, This helps a lot, and thanks for providing the link to the example. If there is one challenge that I have encountered, is the difficulty in compromising the rules of relational databases with the dynamic needs in mental health. Thanks for all the help! :)

Hi Paul, Thanks for the quick reply. What are the limitations of using fields to store values from questions in a survey? I'm not too familiar with the Nz function. I did a bit of research on it and it seems to help me count the number of items with an value vs those with a null value. I...

Hi, I'm pretty new to Access, please forgive me if I misuse some of the terminology, or if I start using a lot of the analytics jargon. I have a table that stores information for multiple behavioral surveys (numerical values). My goal is to add the proper fields that compose total scores value...

Hi, My name is Neri, and I am an outcomes analyst in San Diego, CA. Although most of my training is in analytics and statistics software, I have found myself learning a bit about Access through my new job. As I transitioned into my position, I found myself searching the web for answers to my...