Search results

HELP!! :-) Working on a deadline and this query won't work. Hopefully someone can see something that is obviously. Different criteria apply to different levels . . . any ideas of different OR operator to make this work or do you see something else obvious? Levels: (IIf([SumofMth Life...

Thank you so much!!!!!! This works! Hard to believe a " can make so much difference!

I used this: =[Text15]+[Text16] and it returned 010 or 1010 . . . am I missed the boat here?

Tried that . . . if the numbers are 0 0 10 10 . . . that is what I get . . . 001010

I don't know how to really explain this, but here goes: Example: Name Bonus Amount 4 2nd Amount -2 The bonus amount is calculated by =IIf([Amount]>0,"10","0") . . . and the 2nd bonus amount =IIf([2nd Amount]>0,"10","0") There are about 20 of these all...

Is it possible to sum Iif statements. I have been working on a project that has several Iif statements, i.e. for bonuses, if # is greater than 0, 10, if less, 0 . . . now I need to sum the Iifs, and so far not having any luck. Any suggestions? Thanks!

Thank you for all your help. I did get it to work. For some reason, I had to delete the info in Child Link in the properties for the subreport? Not even sure what that does but regardless, now it works! Thanks so much!

It works to a point . . . it will only show the total for the largest . . . I think I am missing a small detail in the properties? Can you help?

What I would like to do in my report as opposed to building a ton of queries is this . . . I have several columns that rate classes, for example, Excellent, Good, Fair, Poor are drop downs to choose from. In my report, I would like to total that column which I can do =Count([Value]) . . . but I...

Thank you for your reply. I was afraid the answer was no. Here is what I have . . . 300 people are attending a conference and need to be broken into 8 equal groups for break out session. We want them mixed up randomly so not all one department or office is in the same group (so they get to...

At the risk of showing my stupidity in Access, is it possible to record a macro by recording keystrokes or do you have to know code in Access? I have a query that has a column whereby everyone needs assigned to a group randomly. I have the column as a lookup but rather than going through...