"Enter Parameter Value" Blank Input Validation

trksbc

New member
Local time
Yesterday, 16:39
Joined
Jul 27, 2011
Messages
5
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!
 
For a situation like this drive the query from a Form with a listbox for the permitted parameter values.

Brian
 

Users who are viewing this thread

Back
Top Bottom