Solved

Query not pulling correct date

Posted on 2008-06-17
3
222 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

729 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