Link to home
Create AccountLog in
Avatar of kellyputty
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]);

Avatar of Jim P.
Jim P.
Flag of United States of America image

Is the [Enter First Date] less than  [Enter Second Date]?
ASKER CERTIFIED SOLUTION
Avatar of jenleej
jenleej
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of kellyputty
kellyputty

ASKER

Thanks.