Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jinexile
-
Default value for prompt?
That worked, thanks!- jinexile
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Default value for prompt?
nope, also tried AND ([Sawmill Service Records].Shift Like [Enter Shift] OR [Enter Shift] = "" )- jinexile
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Default value for prompt?
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...- jinexile
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
