Improve company productivity with a Business Account.Sign Up

x
?
Solved

Query not pulling correct date

Posted on 2008-06-17
3
Medium Priority
?
236 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

595 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