Recent content by natedog51

Works like a charm! I actually put the field [DueInMth] as a numeric field and put the statement as Eomonth([Create Date])+[DueInMth]. It allows flexibility throughout the whole month. Thanks again!

Mousie, First of all, thanks a bunch! This function works well for projects that are due on the 1st of the following month following the date created [date assigned], however, I need to tweak it a little more and add some functionality to allow for due dates for other days in the month such as...

I'm creating a db that provides project listings in the work queue, along with the due dates and a bunch of other data. I have created a table [recurring projects] that stores the projects that are done frequently. Once I do some field manipulations on this table, I append them to a master...

Works like a CHARM! Thanks so much for your help! I just wish I would have asked earlier rather than spending 4 hrs racking my brain. Thanks Again

I'm trying to create a report eventually, however, I need to get my query set up. My report should look like the following when complete. Timeframe (mth,qtr,year) # of Total Projects Completed - regardless of status # and % of Projects Completed within Requested...

Update - I was able to get a form to hold the dates - thanks for the suggestion, Rich!

Thanks for your suggestion, but what type of form specifically. I hate to sound dumb, but I'm still learning Access.

I'm trying to create a report with 2 subreports embedded. The two subreports are generated from the query. I have one query with detail and the other query is a subquery of the first query that summarizes the data. In the first query with detail, I have the date criteria as "Between...