Recent content by diofree

I have a report that aggregates information on an individual from a table. Basically the report has three columns, each is averaging information. Column1 *If assessment type field = "Lead", average score field values Column2 *If assessment type field = "Self", average score field values...

Got it working in SQL. In the calculated I got it working using IIf(IsNull([PositionIncumbentLastName]) and IsNull([PositionIncumbentFirstName]),"Vacant",IIF(Isnull([PositionIncumbentLastName]) or IsNull([PositionIncumbentFirstName]),trim([PositionIncumbentLastName] &...

Hi guys, I have a simple IF statement that combines First with Last names: IIf([PositionIncumbentLastName]<>"",[PositionIncumbentLastName] & ", " & [PositionIncumbentFirstName],"Vacant") How would I modify this to check if Last Name was empty, or First Name was empty, to only take the other...

Hi guys, I have a form that goes (in simplified way) something like this: Field1 - Position Field2 - Option1 Field3 - Option2 I know this is not ideal but constraints force me to do it this way. I want a rule that basically turns my field red if Option2 has the same value as what is in...

MS Access Database engine does not recognize " as a valid field name or expression? Hi guys, I have a report, pulling off a crosstab query that works fine for awhile, and then stops working and throws this error: "the microsoft access database does not recognize " as a valid field name or...

Silly me, thanks plog.

Hi all, I have a report like in the screenshot below and would like to add a sum row below each Candidate Grouping level to show a roll up of their +-. I want to achieve something like the grey shaded row in my screenshot, is this possible? I managed to get this working for the Assessed Score...

You ROCK! Thank you!

Hi guys, I have a report that shows a gap score between desired score and expected score. Negative values indicate they are not meeting expectation, positive means they are meeting/exceeding. Is there a way to add a + symbol before positive values so that they line up with negative values?

Ok thanks for clarifying for me!

Ok - so very rookie question: Null = "" but are you saying Null is also recognized when a user enters "Null" ? Right now the score fields are number fields because i thought that would be the most versatile to do math on later on in the queries.

Ok got it. The assessment piece is coming out of sharepoint and I saw no other way to do it, so that one piece does have an improper structure, no doubt. The reason '0' was added as allowable was to give the user a null value. Is there any other way to do this other than having the user leave...

Hi guys, I have a query running with the help of some helpful people on this forum, but it is not in the format my users want. Is it possible to change the layout to the way I have diagrammed? Thanks!

Arg, I'm so sorry. To summarize: So if I want each column's AVG field eg. Avg(Assessments.AssessmentLCMExecution) To only average values that are between 1-4. I would do so by adding a WHERE after the GROUP BY, which lists every field like so: WHERE Assessments.AssessmentLCMExecution>0...

Also, I have a sense you won't like this, but any suggestions on converting the query/report from what I'm getting to what the business wants? See attached diagram. If i can get it into that format, I can the gap column working I believe.