Hi guys all has been going well recently, untill ive encountered a wee problem...
Run down:
So i have a Query pulling the following DATA
Contract Name, Vendor Name, Status, Create Date, Design Date , Current Reviewer.
And so far ive got everything working bar the current reviewer.
The info for the current reviewer is based on Create Date and Design Date. How ever the table i want to pull the data from doesn't have anything i can create a relationship with to get the data out or when i can its the wrong data.
What i need:
If the Create date = a Date and Design date = nul then pull this name from tbl_contacts
If the Create date = a date and Design date = a date then Pull Other Name
I can split the Design contacts and Create Contacts into two seperate tables thats not an issue but i need to report the info in 1 colum of the query. Is there any If functions or anything that would help me out?
Thanks for your Time guys!
Run down:
So i have a Query pulling the following DATA
Contract Name, Vendor Name, Status, Create Date, Design Date , Current Reviewer.
And so far ive got everything working bar the current reviewer.
The info for the current reviewer is based on Create Date and Design Date. How ever the table i want to pull the data from doesn't have anything i can create a relationship with to get the data out or when i can its the wrong data.
What i need:
If the Create date = a Date and Design date = nul then pull this name from tbl_contacts
If the Create date = a date and Design date = a date then Pull Other Name
I can split the Design contacts and Create Contacts into two seperate tables thats not an issue but i need to report the info in 1 colum of the query. Is there any If functions or anything that would help me out?
Thanks for your Time guys!
