I have imported a spreadsheet and then created a query - in the query I am trying to format the data. In my spreadsheet there are two fields that a job number can be in. If there is a job number in the Job_Num1 field I want it to pull from there, if there is not a job number in the Job_Num1 field I need it to pull from the Job_Num2 field.
I tried using the NZ function... Job_Number: Nz([JobNum1],[JobNum2])
This pulls the job number if there is something in Job_Num1 but will not pull Job_Num2 when nothing is in Job_Num1.
Any help is appreciated ...I feel like this is something simple that I am missing??
I tried using the NZ function... Job_Number: Nz([JobNum1],[JobNum2])
This pulls the job number if there is something in Job_Num1 but will not pull Job_Num2 when nothing is in Job_Num1.
Any help is appreciated ...I feel like this is something simple that I am missing??