George,
The problem is I dont know how to create View that i why i am using just SQL Query.
I will quickly check tutorials on creating View and I will try it out.
Presently, the system is reporting error because all of the Calculated fields (ExpiryDate & A_WeekB4Expiry) are not recorgnized as a valid field names.
The solution you sent still did not bring result.
I will try and readup on View and create it.
Thank you very much except you have any other solution. I really appreciate it. God bless.
Samson