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
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: