Default value for prompt?

[jinexile]

I have a query that prompts for the date and shift for downtime of certain departments. I want to be able to select a specific shift or all if none is entered.

here's a snippet of the sql:
WHERE ((([Sawmill Service Records].ServiceDate) Between [Enter Start Date] And [Enter End Date]) AND (([Sawmill Service Records].Shift) Like [Enter Shift])

 

[Golom]

Try something like

WHERE [Sawmill Service Records].ServiceDate  
      Between [Enter Start Date] And [Enter End Date] 

AND ([Sawmill Service Records].Shift Like [Enter Shift] OR
     Len([Enter Shift]) = 0 )

 

[jinexile]

nope,

also tried

AND ([Sawmill Service Records].Shift Like [Enter Shift] OR
     [Enter Shift] = "" )

 

[Golom]

The problem may be that you don't have a mask on your like clause. Try this

AND ([Sawmill Service Records].Shift Like [Enter Shift] & '*' OR
     Len([Enter Shift]) = 0 )

 

[jinexile]

That worked, thanks!