• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Query not pulling correct date

The following query is pulling all dates from the table instead of the parameters enter by the user.  Any thoughts?

SELECT [Raw Plate Table].Filler, [Raw Plate Table].SPC, [Raw Plate Table].Coli, [Raw Plate Table].[Production Date]
FROM [Raw Plate Table]
ORDER BY ([Raw Plate Table].[Production Date] Between [Enter First Date] And [Enter Second Date]);

0
kellyputty
Asked:
kellyputty
1 Solution
 
Jim P.Commented:
Is the [Enter First Date] less than  [Enter Second Date]?
0
 
jenleejCommented:
Wouldn't you want a 'WHERE' clause?  WHERE [Raw Plate Table].[Production Date] > [Enter First Date] and [Raw Plate Table].[Production Date] < [Enter Second Date]
0
 
kellyputtyAuthor Commented:
Thanks.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now