Stewart,
I was able to fix the query as you suggested and now the report works perfectly. Thank you very much for the timely suggestion. I was about to scrap it and start the report a whole different way.
Thanks for your help,
Dan
User Profile
Collapse
-
-
Ok so I tried doing things a little differently and have gotten further but I am having trouble getting the 2 queries to link together. Here is the code for the two queries:
Query 1
qryDateRange5
...Code:SELECT tblContractorOnProject.Date, tblContractorOnProject.Project_ID FROM tblContractorOnProject WHERE (((tblContractorOnProject.Date)>=[Forms]![popupDateRangeDateCheck5]![txtStart]));
Leave a comment:
-
Stewart,
Thank you for the detailed reply. I will give that a try and see what I can come up with.
Thanks,
DanLeave a comment:
-
Date Range Issue
Hello,
This is my first time posting on here so I hope I don't ramble too much. I have a complex database that a co-worker and I created 2 years ago and that I have been adding to since then. The database allows us to keep track of projects that we are quoting and all of the important information related to those projects. Each project can be quoted to several customers on completely different dates.
My problem comes with the...
No activity results to display
Show More
Leave a comment: