"Enter Parameter Value" Blank Input Validation (1 Viewer)

trksbc

New member
Local time
Today, 02:08
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!
 

Brianwarnock

Retired
Local time
Today, 09:08
Joined
Jun 2, 2003
Messages
12,701
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

Top Bottom