Search results

Thanks, both ideas work!

You don't need all that extra stuff after DoCmd.Close. It's just a button with DoCmd.Close as its Click event. T

Instead of just putting "or" in between the values, you have to put " [fieldname] = 'selection1' or ". Also, use ' (single quote) in code rather than " (double quote). So the final result would be something like "Select * from [table] where [fieldname] = 'Red' or [fieldname] = 'Blue';" T

You could make 3 fields in your query, like this: Val1: iif ([30 Day] > 0, 1, 0) Val2: iif ([60 Day] > 0, 1, 0) Val3: iif ([90 Day] > 0, 1, 0) Then a fourth like this: Sum: [Val1] + [Val2] + [Val3] Sort it by [Sum] and set the Top Values propery to 1. That should do it. I don't know if...

Hi all I have seen similar questions to this one throughout the forum, but no answers. Maybe it's just not possible? How do I display (either through a Query or on a Report) the top 3 values (or the last 5 records) for each employee? There is a option to display the top 3 values of the whole...