Query issue - Does not see dates with previous year.

[saustin1967]

Stumped.
I have an Access 2003 database with a query that will pull data from table for the current year just fine.


When I try to query a previous year, i.e. any date in 2013, I get no records returned, just no data.
There are records for these dates in the table, and if I set my computer date back to 12/31/13 I can pull all the records for that year.

Only parameters on the query are the date
>=[PDateS] and <=[Pdate2]

What am I missing?

[June7]

What are PDateS and PDate2? Are these popup inputs?

Post the full SQL statement.

[saustin1967]

June7, I thnk you may have inadvertantly pointed me to the solution.
I hate following someone elses work.
When I pulled up the SQL for this query I found this:

SELECT DISTINCTROW Month([prod_day]) AS FMonth, tbl_press_run.upd_time, tbl_press_run.prod_day, tbl_press_run.product_name, tbl_press_run.shift, tbl_press_run.press_run_min AS [RUN MINUTES], tbl_press_run.pressload_actual AS PL, [Pressload Product Input Factors].[Footage/Pressload] AS FT, [PL]*[FT] AS TOTAL, [Pressload Product Input Factors].[GOALS/HOUR], ([RUN MINUTES]/60*[GOALS/HOUR]) AS GOAL, [PL]/[Goal] AS [%Goal]
FROM [Pressload Product Input Factors] INNER JOIN tbl_press_run ON [Pressload Product Input Factors].Size = tbl_press_run.product_name
WHERE (((tbl_press_run.prod_day)>=[PDateS] And (tbl_press_run.prod_day)<=[PDate2]) AND ((Year([upd_time]))=Year(Now())));


LOL, why would the previous admin include this
Going to modify it and see if that resolves my issue, Thanks
Will post results.

What are PDateS and PDate2? Are these popup inputs?

Post the full SQL statement.

[saustin1967]

That worked!

Thanks for the assist.