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