How to set Default value for Parameter in a query using a paramete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following Query

PARAMETERS [Enter the Case ID] string;
SELECT RespondentFirstName, RespondentMiddleName, RespondentLastName,
FROM Preload1
where caseID = [Enter the Case ID];

How can I set a default value for the Case ID so that when a user runs the
query a default value is shown (That is the value most users want 7 times out
of 10)

Any ideas or help is apprecitated.

Jawahar
 
You can't in a parameter query. You can use the NZ function to force a
value if they leave it blank

Where CaseID = NZ( [Enter Case ID (Blank = 123)],123)

IF you need more control over the value or want to use default values, then
you need to use a form and controls to get the data.
 
Back
Top