Search results

That worked PERFECT!!!. Thanks so much. :):):):)

CJ_London, thanks for the input but I am not sure I can use it. Let me give you more info. On the report there is a switch command that decides based on another field what to do with the number I listed. =Switch([Attainment_Format]="Percent",(Int([Attainment]*10000)/100 &...

This works great. Thanks so much. One small thing (I know I'm pushing my luck here). If I have a number that reads, 0.9730902123, the result displays 97.3%. Any chance I can get it to ready 97.30%? I can live without it but for display purposes it looks out of alignment with the...

I have a field that comes from a make-table and is set to Double. This field is used to display different types of values like .994965 as well as 47 and 1.08. So changing the field type is not an option to meet my need. I need to display all the data that reads .994965 or any number similar...

I have a need to evaluate 185 records and perform a calculation for each record using IIF statements but my IIF's are too long. Basically I want to create a new field called BonusAmt. In this filed I need it to evaluate different columns and produce an answer per row. I do not know VBA very...

I put it in an Excel file so I could give you more information. It has 2 sheets. The first is what the data looks like and Sheet 2 is what I need it to look like. Thanks so much.

Thanks so much. However, there are about 120 people and each one of those people can have at least 2 records listing Sales & DCP or they have another title however it contains DCP. Each one of those people are measured on if they reach their DCP goal and if they do AND they reach their Sales...

There are about 120 people and each one of those people can have at least 2 records listing Sales & DCP or they have another title however it contains DCP. Each one of those people are measured on if they reach their DCP goal and if they do AND they reach their Sales goal then it is calculated...

I have a situation that I hope can be done without using VBA. Let's say table looks like this. Name Type Amount Percent Bonus John DCP 5000 10 John Sales 4000 5 I need to look at record one and if John's DCP Amount is >=4000 AND his Sales are >=4000 his Bonus amount for...