Recent content by JLM

Thank you all with your patience with me! I got the calculated fields on the forms to work. There is one that sums up what each student has earned, including bonuses; one that sums up how many available points there are, excluding bonuses; and one that calculates the percentage the student has...

Ok so let me see if I have gotten my brain around this..... On my from for FBLA Membership I need to have a control to display the total points a student has earned. This control is a DLookup to a query. The query should have the fields: the student's name from join table event participation...

Ok I'm a bit, actually a lot, confused. I know I shouldn't store a calculated value in a table. And now you're saying using a query as a control source on a form is not a good idea. But I need to be able to pull up a kid and tell how many points they have accumulated so far and that percentage...

I have managed to build a query that will look up how many points a student should get for attending an event. I will use that as the control source for my form when I get there. What I'm not sure how to do is the bonus points and certification points. Is that a query or will I need to build...

Ok I think I have managed to normalize my database. I ended up getting rid of all the forms I had already created since they referred to fields and queries that no longer existed (I got rid of all my old queries and started them over). I think I have managed to zip and upload the database as...

Thanks for explaining that. I saw normalization referred to in a few other threads and tried to read up on it, but (probably because it was near the end of my work day) I couldn't follow the explanations. Let me rework those things and see what I can do from there. I'm sure I will be back!

If you can walk me through how to upload I can try. As far as what the report needs to look like, something like below I think Student: John Smith Student ID:12345 Class: 10 {other general info straight from data entry, telephone dues paid etc} Bonus Points: Excellent at District <-----only...

I need some advice about a project for my hubby. I have mucked around with Access for probably around 10 years, and I can usually find the answers to what I need in forums like this and other web places, or if I'm lucky someone better with it works in another department. This time though I think...

Oh in this case is absolutely right! It will be so much easier to keep track of this in a database than an Excel spreadsheet. It just doesn't lessen my headache at all!:D

I have dabbled in Access off and on for about 10 years and usually I can poke around the net and find places like this that will answer my questions. But not this time! My husband has got me going in circles! :banghead: