Recent content by Phoebe

I will take a look at both links right now, thanks so much!

Again, many thanks for your help. I am enjoying learning Access but realize that I may have gotten in a little over my head on this. Please realize this is a work in progress, and I had to delete some of the things I had done that reflected any company info and had to replace all the employee...

I can certainly do that and would be grateful for the help. Can I just attach them to a reply or is there something else I need to do first?

I'm afraid I'm still getting the same error message. I really appreciate the help, I wish I knew more and could help! It doesn't look like I'm missing a paren or anything like that.

I put a space before the WHERE and I still get the same error. Any other ideas? I have no doubt that it's me, I just can't figure out what I'm doing. And yes, it is a direct copy and paste from the Query.

The error reads: "The expression you entered contains invalid syntax. You may have entered an operand without an operator"

First, Thanks! This makes perfect sense if I can just get it to work. I keep getting an error message. My two tables are TotalPointsT and MonthlyPointsT, with the field name "SumOfPoints" in both--can you help me fix the error in the following? UPDATE [TotalPointsT] INNER JOIN...

Hello again, I am trying to finish a database that keeps track of points employees accrue when they miss work. I have the forms set up to enter the info daily, as well as the queries that automatically sum the points. My problem comes when I try to SUBTRACT points. When an employee has a...

Great, thanks, that helps! Any suggestions on how to perform the actual calculations? I know I have to add all the points and do an If Then, but I am a little fuzzy on the actual logic.

Hello Experts, I have been beating my head against a wall trying to figure out the best way to do the following. I have a table containing "points" that people accrue for late arrival, not working a full day, etc. If an individual has perfect attendance for a month, they automatically...