Between Query (Dates)

Vav

Registered User.
Local time
Today, 07:45
Joined
Aug 29, 2002
Messages
36
Hello,

Got a question. I have to run a report which will show all the work in progess during two given time periods.

I have made a query which goes like this:

SELECT [tbl_Production_Release].[PR_Company_Name], [tbl_Production_Release].[PR_Cust_Code], [tbl_Production_Release].[PR_Order_Number], [tbl_Production_Release].[PR_Acc_Rep], [tbl_Production_Release].[PR_Enter_Date], [tbl_Production_Release].[PR_Due_Date], [tbl_Production_Release].[PR_Prod_Release], [tbl_Production_Release].[PR_Release], [tbl_Production_Release].[PR_Prod]
FROM tbl_Production_Release
WHERE.......
**** this is the part where i get stuck. I know I have to add a BETWEEN AND in there somewhere but I don't know where.


I want it to do something like

[tbl_Production_Release].[PR_Enter_Date]>=[Enter Date] And [tbl_Production_Release].[PR_Due_Date]<=[Due Date]


AM i even on the right track?

Any help would be appreciated.

Peter Vav
 
Last edited:
Just use what you got...
SELECT [tbl_Production_Release].[PR_Company_Name], [tbl_Production_Release].[PR_Cust_Code], [tbl_Production_Release].[PR_Order_Number], [tbl_Production_Release].[PR_Acc_Rep], [tbl_Production_Release].[PR_Enter_Date], [tbl_Production_Release].[PR_Due_Date], [tbl_Production_Release].[PR_Prod_Release], [tbl_Production_Release].[PR_Release], [tbl_Production_Release].[PR_Prod]
FROM tbl_Production_Release
WHERE [tbl_Production_Release].[PR_Enter_Date]>=[Enter Date] And [tbl_Production_Release].[PR_Due_Date]<=[Due Date]

Should work beautifully...

Regards
 

Users who are viewing this thread

Back
Top Bottom