Recent content by dp1981

ok, i think i finally got it (fingers crossed!!!). Can someone look at this to see if I'm on the right track maybe? You guys have been SOOOOO helpful so far and I never would have gotten this far without you! So I just want to make sure I did it right if someone has a second to double-check it...

Um, huh??? From the looks of what you wrote, you definitely get it better than I do...because I'm confused. I've sat and looked at this several times over the past day, and I'm no less confused than when I started looking at it! I told you, the relationship part for me just doesn't compute well...

I have no idea WHY I can't seem to figure out how to construct relational tables, but I just can't get it! I've built 2 other databases, but always had to come here for help on making the tables. So here I am again, only this is a bit more complicated than those I've posted about before. So I...

HAHA! Funny Paul! I tried it. It worked. Problem solved. Boss can get off my arse now. You're a lifesaver! :-D

you guys are silly! holy cow! :-D thanks for all the suggestions! i knew it was something simple. i'm going to try paul's suggestion first (uh, nothing personal but it seems simpler...lol). if that doesn't work, you guys definitely explained the left-mid-right thing to me. i appreciate it, as...

Hmm, i think i'm not understanding the numbers placed in the Query, Joey (or Ken, for that matter, too!). I get the theory of splitting it up, and it sounds good...just confused a bit by the numbers. Would you mind explaining that a bit? Banana, glad I could teach you something. That is...

Weird. Actually, the dash is still in my original tbl. After I went into design view, I realized I incorrectly identified something that could be imperative to know. It was NOT an input mask, but rather a format that I have entered for the SSN field. The format I placed was "@@@-@@-@@@@"...

I know this is probably the dumbest thing to ask, but I am just not getting it. I'm tryin to run a Query, and I assume it's a SELECT query for Last Name, First Name, SSN. The tbl containing this information [tbl_Employees] automatically places the dashes in the SSN through an input mask. However...

That's the problem. The way my supervisor wants the report is grouped by employee location. So the report has many different locations. Then alphabetical employees. Then the courses/dates. That's why I can't get it to work by just counting over groups in the report. But thanks for the quick...

I finally am figuring out this Access db stuff. I have managed to produce what I believe are normalized tables, built a query or two, and now a report. However, what I need to do now is something that I don't even know is possible. Further explanation is that I need to produce a query that...

Thank you so much for the time you've taken to guide me through this and help me with the basic structure. I'm very appreciative! "Activity" is actually another way of saying "Sub unit" but they refer to it as "activity" for some reason. So it IS possible to have a job have only one activity...

Ok well I think I've come up with something...but am a little unsure about my "tbl_Job" setup and whether my new way of doing this is set up correctly. Can someone take a look at my attachment and tell me if my relationships will work please? CraigDolphin, you definitely got me further than I've...

Wow, now I'm really confused. I see definitely some of the things I know are needed in my db. But some of the fields you created [such as "employee-specificfield1"] I don't understand. I swear I'm not an idiot. I can do the more difficult things in Access, like make 2 combo-boxes dependent on...

need to know if an employee has done a course, and when they completed the course

Um...I'm not too sure what you meant, to be honest. Of course I want to create a normalized db. But to do that, I need to have relational tables. And THAT'S the part I'm struggling with...?