AnsweredAssumed Answered

Nested If Statement

Question asked by ShanaEichleberger on May 16, 2012
Latest reply on May 16, 2012 by philmodjunk


Nested If Statement


I want to pull a number from another time but I have two criteria that must be met. 


Right now i have 

If (Daily Reports::Jobnumber=Daily Vehicle Reports::Job Number1; If (Daily Reports::Date=Daily Vehicle Reports::Date; Daily Vehicle Reports::JOb Site Mileage Average;0);0)

But its not returning the results.

I just want the Job Site Mileage Average to pull if the job number and dates match