Solved

Query not pulling correct date

Posted on 2008-06-17
3
219 Views
Last Modified: 2012-06-27
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
Comment
Question by:kellyputty
3 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 21805029
Is the [Enter First Date] less than  [Enter Second Date]?
0
 
LVL 1

Accepted Solution

by:
jenleej earned 500 total points
ID: 21805059
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
 

Author Closing Comment

by:kellyputty
ID: 31468045
Thanks.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question