Hi,
I have a query which takes an input from the user and gives required details for that quarter, like Week ending date, month, etc. When no quarter is selected, the query result is blank. I want to introduce a validation wherein the user is forced to enter a value, and blank value is not accepted.
Below is my Select query:
SELECT Week_Table.Week_Ending AS [Week Ending Date], Week_Table.C_Month AS [C_Month], Week_Table.C_Year AS [C_Year]
FROM Week_Table
WHERE (Week_Table.C_Quarter)=[Select the Quarter: ];
Thanks a lot in advance!