kellyputty
asked on
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]);
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]);
Is the [Enter First Date] less than [Enter Second Date]?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks.