Search results

I have a table with DriverName, DateOfAbsence, AbsenceReason as fields. I want to count the number of absences each driver has by month. Would I need a "Month" field?

Sorry for the lag time! Thanks so much for your help!

I hope this is an easy question... If I have several entries for the past few years, is there a way I can query for a certain month's worth of data? For example, I have 3 years worth of data, including a date field, but I need to find all entries for May 2011. Thank you for your help! Using...

Of course I was editing the wrong query.... It's been a Monday all week. Thank you.

I'm not sure what I'm doing wrong. I've added the expression, but I only get null responses. Shouldn't the output look like: (qryYTDPointSummaryForAllDrivers) pkDriverID....LastName........FirstName............YTDPoints.. ...030...........Smith.................Joe....................95...

Lord have mercy! If you had a support button, I'd sure use it. Thank you again.

One last question for the day...When I run the report, I'd like to see everyone's score. If they have had no point transactions, then I'd like to see 95 as their "score". I joined the tblDrivers to the qryYTDPointStatus, then changed it to 2: Include ALL records from tblDrivers.... (please see...

Integer is correct. No decimal places. I'm looking at the forms and tables now. You've nailed it. Thank you so much for taking the time to show me how to do this!

This is beautiful! I need to get into an Access class immediately. It absolutely works for my needs. Can you tell me what the Ing in IngPoints means? Can I now create a query on the amount of points retained by each driver? Thank you immensely! I'm learning so much just by taking apart the...

JZWP, in the tblPointTransactions, how do I get the dropdown for Driver ID? Is it possible to use Lastname as the lookup?

I'm looking at this structure. It makes sense, and I really like it better than what I came up with (I'm so new at this...). I bet this saves a lot of headaches for me. Thanks so much!

Thank you! This formula fixed what I was missing!

Sorry, NEW DriverTotalPoints is the query. Another problem with the IIF is that I can't get a total to show if there are no offense points taken.

In the beginning, the committee wanted the drivers to start out with zero points. Offenses would drive up the points (30 in one year gets one released from their duties). Now, to put a positive slant on the program, the drivers will start out at 95 and lose points as offenses are made. On...

Hi, I have a database to keep track of bus drivers' points. For any negative actions, they have points taken away, for any positive, they have points added (I wish this would work for my kids...). But now, instead of just coming to a maximum of 30 points before letting that driver go, HR wants...

Hi all, I'm a GIS Analyst working for a local government agency. I'm interested in getting some workflow more standard and useful. I've been learning Access by Lynda.com and will take Access at the local community college this coming summer. I've asked a question and found many other answers...

I'm still having trouble with this. In my DriverTotalPoints Query, I've TOTALED each column (achievement points and offense points). When there is a total for each column per person, the Total column works with the expression.... Total...

So sorry! I'm using Access 2010. And your comparison to a bank account truly helps! Thanks so much!

We have started a "points program" for our bus drivers. Each offense they incur adds points to their score. This is a yearly cycle. So, I need to keep track of the points they earn, adding them up by year. Thanks!