Search results

I'm looking to use the DCount function on a report as the Control Source. I need to be able to have a count of Shop Orders within my Work Center group. For example, if I have a WC of 1001 and there are 12 SO's, I would like there to be a footer for the count total. Using the DCount becuase there...

I have an ID field that needs to be reset each new year, once records are archived (starting back with 1 then increment with each new record). I am able to get the 1st record entered starting with 1 after I purged (testing) records. However, when I go to add another record, it wants to keep...