What I have is a database with sales information and labor information. I have a simple calculation figuring out the daily labor cost % (labor $ / sales $). They would like to see a WTD (Week to Date) and MTD (Month to Date) labor cost on the same report. The company's week runs from Friday to Thursday. I'm stuck on what I need to do to get this to total the sales and labor for WTD or MTD so I can have it figure out the % and put it on the report. I'm pretty sure it will need to be done in VBA which I have limited experience in. I'm not a professional so please bear with me, I appreciate any help anyone can give me.
WTD- this would need to figure out the sales $ total and labor $ total from previous Friday to current date and divide the labor by the sales to give me a percent
MTD- this would need to figure out the sales $ total and labor $ total from the 1st of the month to current date and divide the labor by the sales to give me a percent
Thanks again everyone.