Hello Everybody,
I need some assistance with a query for a report. I have googled a few things, but not sure if I am asking for the right thing. I need a report query to check a column for a date. If the date is blank then I need it to take the value from another column. So the one column is entered in when the task is completed, but if it is not completed then it needs to take the projected date which is in another column. The column name that it needs to check first is final report sent, if no date is in that column then it needs to check final report due date. I need it to display just two columns which I can figure out. It will also be ran from a date range within a form, but I also think I have that covered as well. It is just this goofy query that I need help with. Thanks!!
I need some assistance with a query for a report. I have googled a few things, but not sure if I am asking for the right thing. I need a report query to check a column for a date. If the date is blank then I need it to take the value from another column. So the one column is entered in when the task is completed, but if it is not completed then it needs to take the projected date which is in another column. The column name that it needs to check first is final report sent, if no date is in that column then it needs to check final report due date. I need it to display just two columns which I can figure out. It will also be ran from a date range within a form, but I also think I have that covered as well. It is just this goofy query that I need help with. Thanks!!