|
|
||||||
|
#1
11-03-05, 09:03 PM
|
|
|
|
|
I have looked until cross-eyed at this and cannot find the problem:
iif([tbl_NewPayroll]![Code1]=”01”,[tbl_New_Payroll]![Hours1],iif([tbl_NewPayroll]![Code2]=”01”,[tbl_New_Payroll]![Hours2],iif([tbl_NewPayroll]![Code3]=”01”,[tbl_New_Payroll]![Hours3],iif([tbl_NewPayroll]![Code4]=”01”,[tbl_New_Payroll]![Hours4],iif([tbl_NewPayroll]![Code5]=”01”,[tbl_New_Payroll]![Hours5],iif([tbl_NewPayroll]![Code6]=”01”,[tbl_New_Payroll]![Hours6],iif([tbl_NewPayroll]![Code7]=”01”,[tbl_New_Payroll]![Hours7],iif([tbl_NewPayroll]![Code8]=”01”,[tbl_New_Payroll]![Hours8],iif([tbl_NewPayroll]![Code9]=”01”,[tbl_New_Payroll]![Hours9],[tbl_NewPayroll]![Code10]=”01”,[tbl_New_Payroll]![Hours10]))))))))) I also tried this with no luck: Switch([tbl_NewPayroll]![Code1]="”01”",[tbl_New_Payroll]![Hours1],[tbl_NewPayroll]![Code2]="”01”",[tbl_New_Payroll]![Hours2],[tbl_NewPayroll]![Code3]="”01”",[tbl_New_Payroll]![Hours3],[tbl_NewPayroll]![Code4]="”01”",[tbl_New_Payroll]![Hours4],[tbl_NewPayroll]![Code6]="”01”",[tbl_New_Payroll]![Hours6],[tbl_NewPayroll]![Code7]="”01”",[tbl_New_Payroll]![Hours7],[tbl_NewPayroll]![Code8]="”01”",[tbl_New_Payroll]![Hours8],[tbl_NewPayroll]![Code9]="”01”",[tbl_New_Payroll]![Hours9],[tbl_NewPayroll]![Code10]="”01”",[tbl_New_Payroll]![Hours10]) I am using this in an update query, the second attempt gets me a parameter message looking for the "True" field. Anyone have an idea? Thank you |
|
|
|
#2
11-03-05, 09:57 PM
|
|
|
|
|
My suggestion: Use a Select Case Statement or a loop rather then this many
nested IIf's. But looking at your first mess of IIf statements, you don't have an IIf for Code10="01" and a final statement of what happens if it is none of these--I added a 0 for this and another paranthesis: iif([tbl_NewPayroll]![Code1]=”01”,[tbl_New_Payroll]![Hours1],iif ([tbl_NewPayroll]![Code2]=”01”,[tbl_New_Payroll]![Hours2],iif ([tbl_NewPayroll]![Code3]=”01”,[tbl_New_Payroll]![Hours3],iif ([tbl_NewPayroll]![Code4]=”01”,[tbl_New_Payroll]![Hours4],iif ([tbl_NewPayroll]![Code5]=”01”,[tbl_New_Payroll]![Hours5],iif ([tbl_NewPayroll]![Code6]=”01”,[tbl_New_Payroll]![Hours6],iif ([tbl_NewPayroll]![Code7]=”01”,[tbl_New_Payroll]![Hours7],iif ([tbl_NewPayroll]![Code8]=”01”,[tbl_New_Payroll]![Hours8],iif ([tbl_NewPayroll]![Code9]=”01”,[tbl_New_Payroll]![Hours9],iif ([tbl_NewPayroll]![Code10]=”01”,[tbl_New_Payroll]![Hours10],0)))))))))) "Jeff C" wrote: [..] |
|
|
| Similar Threads | |
| Untangle, SBS 2003 R1 and Slow DNS We're running SBS 2003 R1. We're getting ready to upgrade hardware and software to SBS 2008. Since ISA is supposed to be on the SBS 2008 box, we've been looking at putting an... |
|
| Untangle and SBS 2003 R1 We've added an Untangle firewall server between the Internet (DSL modem) and our SBS 2003 R1 server. Something is not configured correctly and I haven't yet found an answer... |
|
| O.T. Anyone Purchase a Untangle Device? or Use Untangle? I'm thinking of going back to Linux on a PC for Firewalls (I know what you are saying) But I remember using Smoothwall and thinking wow this is cool. I have yet to set up a... |
|
| Untangle - re: Metavize FYI, Anyone used the "Untangle" (previously Metavize) product? Was forwarded the article linked below by one of my techs and seems like something I'll look into as there... |
|
| algorithm to untangle a graph Hi, Does anyone know of a good algorithm to untangle a graph? Or to be more precise: Does anyone know of a good algorithm that will determine the arrangement of vertices... |
|
|
All times are GMT. The time now is 12:40 PM. | Privacy Policy
|
Untangle a mess