Recent content by bodhi23

I've got the report counting the number of students per major, and calculating the number of hours per major. It will also total the number of hours per school/college (the larger group). What I can't get it to do, is reference the subreport of student count by major, in order to obtain a...

RainLover, Pat Hartman, I tried all manner of D*** functions, they seem to only report the first result. RainLover, apologies, I'll try to remember that next time. vbaInt, thank you for your help. I'll take a look at what you've got. I know the tables aren't normalized properly, it's...

Just the objects necessary to run the report in question, with a significant portion of data removed. (The original tables are not my construction, inherited the database. Working on more normalization, it's just a big project.) Suggestions for getting a unique student count on that report...

Because it counts the number of records in our hours table, not the number of individual students. (i.e.: There are 133 Biology majors, but a count based on the hours report returns 1488, which is the number of records from Biology majors - not the number of students) A suggestion for forcing...

:banghead: I'm giving myself a headache... If someone would be so kind as to point me in the direction of a solution, I would be grateful. I have a report which should count the number of students and provide the number of hours of service for each major, and then the total of each for the...

I figured out a work-around. And sent some feedback to Microsoft - as if it will do any good... damn limitations. I had to split what I wanted, and since the expression became simpler, I could use 1 nested IIF statement and one standard IIF. Here are the two statements I worked out...

Ok, yesterday was a busy day and I didn't have a chance to get back to this until now. I have played around with brackets and parenthesis in the expression based on the syntax provided by Raskew - which was determined to be a functional expression. When I put parenthesis around the expression...

A07 is a royal pain. There are some things that A03 did very well that seem not to work in A07 at all... (like, you can't export a report to Excel - could do it in 03, but not in 07 for some reason... ) What I mean is, anything that would evaluate as true in the first three parts of the...

Here's the last thing I'm doing on it tonight: Expr1: Switch([CountOfTotal Time]>=25 And [Level]=1 And [CountOfAttended]=10,"Level 1",[CountOfTotal Time]>=50 And [Level]=2 And [CountOfAttended]=10,"Level 2",[CountOfTotal Time]>=75 And [Level]=3 And [CountOfAttended]=10,"Level 3",True,"No Level")...

Raskew, Thanks - that's much closer to what I'm looking for. I wouldn't use a >= for the training sessions, as each level contains only 10, and you can't move up a level until you attend all 10 sessions - that one will always be "=". But I did figure out the >= for the number of hours just...

Ok - how 'bout this? I already have queries that pull the numbers I'm concerned with. So if I put those two queries into another query with my list of tutors table and make an outer join on the id fields, I get a list of all of my tutors with the number of hours and the number of training...

..as mud, yes. :o I've got a query already that counts the face to face hours - those aren't attached to levels - we just know that 75 hours means the tutor can move to level 3 if they've got the requisite training... If I create a 2nd and maybe 3rd query as you're suggesting, how would I...

Um, I'm sorry - I forgot to mention VBA is a foreign language to me... I've been working with Access for only a few years, and I know just about enough to get myself into trouble with it if I'm not careful... Most of the more advanced coding is a bit beyond my current level of expertise. We...

Hi all - I've been poking around for something that will help me formulate an expression for this, and I've found some things that are very close, but not close enough for direct application... I expect someone will tell me if I'm going about the the completely wrong way, I am looking for the...

RuralGuy: I played around with the expression you gave me and this: (CInt(Nz([HrsEarnedFall]))+(Nz([HrsEarnedSpring]))+(Nz([HrsEarnedSummer]))) worked perfectly. Thank you. Rich: I am still interested to hear your thoughts on database configuration...