Aug 17, 2007 #1 mlrmlr Technical User Joined Mar 17, 2006 Messages 168 Location US Hello, I have a query that I would like to use a parameter to execute one date. I know how to create a Between parameter but not a single. Thanks.
Hello, I have a query that I would like to use a parameter to execute one date. I know how to create a Between parameter but not a single. Thanks.
Aug 17, 2007 1 #2 lespaul Programmer Joined Feb 4, 2002 Messages 7,083 Location US Code: SELECT * FROM SomeTable WHERE SomeDate = [Please enter the date to search] Leslie Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual Essential reading for database developers: The Fundamentals of Relational Database Design Understanding SQL Joins Upvote 0 Downvote
Code: SELECT * FROM SomeTable WHERE SomeDate = [Please enter the date to search] Leslie Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual Essential reading for database developers: The Fundamentals of Relational Database Design Understanding SQL Joins
Aug 22, 2007 Thread starter #3 mlrmlr Technical User Joined Mar 17, 2006 Messages 168 Location US Leslie, Thank you for your assistance. Upvote 0 Downvote