Recent content by leetx

Hello - I am trying to build a database (Access 2010) for another department in my company to use. (It started simple, but as I'm sure you can appreciate has grown my more complicated.) At any rate, I have a login form but I cannot figure out how to restrict the records on other forms to just...

Hello - I am pretty new to Access 2007. So far I have been able to do ok, but I have this one part of my database that is really giving me a hard time. We collect demographic information on the clients we serve (Age, Race/Ethnicity, Gender, Education Level, and Household Income). The form is...

Yes - headache is a good word for this. I've gone through a few different options with none of them being exactly what I need. I don't know if this matters in terms of design - but my demographic form is anonymous. We don't ask them to put a name. It's really more about capturing data...

Good point about the age range. I'll have to review that and determine what exactly we'll be using the data for. I had thought about creating a table to store all the races, but would I add a new record for each time a person checks more than one box? For example, someone checks Asian and...

Yes - I have all that. The problem is so much with the table as it is with figuring out how to set up that particular field. As I said, if it's a drop down box that allows multiple options, you can grab those items in a report. You would have to run a report for all the different combination...

Hello - I'm fairly new to Access and I'm stuck on how to structure my demographic table. I currently have one table for demographics that tracks the following: Racial Background Gender Age Range Household Income Education Level For all categories except Racial Background, there is only one...

Thank you so much for the quick response. I'm still pretty new to Access - so it will take me some time to digest these suggestions and put them into practice... Hopefully I won't have to many problems... - L

Hello - I'm not sure if this is possible and my guess is that I need to know more about SQL than I do.. but here it goes: I have a gardening database and for each plant I want to calculate the planting date based on a certain number of weeks. For example, Plant A should be planted 4-6 weeks...

Hello - I work for a non-profit and we have a database with a table that holds all of the demographic information on each family we serve. That table is linked to a table of Schools in a one to many relationship. (One school can have multiple demographic records). In each demographic record...