basshead22
Registered User.
- Local time
- Today, 07:25
- Joined
- Dec 17, 2013
- Messages
- 52
Hello All,
It's been awhile since i wrote in here.
Here is my scenario. I have a query that has several IIF statements based on the FTE count. I want the return result to be formatted as a number so when i do my total field it gives me back the correct number. Right now if i do a total based off the results it doesn't treat the results as a number it pretty much just concatenates both fields.
example Field #1
Program FT: IIf([PM_PC_PROGRAM]="Program" And [FTE]=1,"1","0")
Result = 1
example Field #2
Program PT: IIf([PM_PC_PROGRAM]="Program" And [FTE]<1,[FTE],"0")
Result = 1
Example Field #3
Total FTE: [Program FT]+[Program PT]
Results = 1.1 Instead of 2
Please help !!! i'm breaking my head all morning!!! :banghead:
It's been awhile since i wrote in here.
Here is my scenario. I have a query that has several IIF statements based on the FTE count. I want the return result to be formatted as a number so when i do my total field it gives me back the correct number. Right now if i do a total based off the results it doesn't treat the results as a number it pretty much just concatenates both fields.
example Field #1
Program FT: IIf([PM_PC_PROGRAM]="Program" And [FTE]=1,"1","0")
Result = 1
example Field #2
Program PT: IIf([PM_PC_PROGRAM]="Program" And [FTE]<1,[FTE],"0")
Result = 1
Example Field #3
Total FTE: [Program FT]+[Program PT]
Results = 1.1 Instead of 2
Please help !!! i'm breaking my head all morning!!! :banghead: