Recent content by fireflyfranch

Thank you I figured out a work around.

2013 - 12/23/12 to 12/21/13 2014 - 12/22/13 to 12/27/14 2015 - 12/28/14 to 12/26/15 2016 - 12/27/15 to 12/24/16 2017 - 12/25/16 to 12/23/17

It needs to be the week before the week that has January 1st in it. Counting 7 days before that date will not always work.

How do I run a query for the last week of the previous year and the current year excluding the last week?

Conditional Formatting wizard

I have a report that I have a text box set to change color based on a subreport through conditional formatting. It looks like that conditional formatting is working but only in the print preview. I does not show up in the report view or when I print. The text boxes in front are transparent and...

I figured it out. Thank you again for your help.

Thank you for your help. My PK/FKs have been fixed. The Employees table is apart of the actual database not in the copy I uploaded. The form/subform/subform helped out a lot. The schedule entry is for entering in who was where. The EmployeeHours, TimeCardCheck, EmployeeInCharge fields are for...

I am making a schedule tracker for keeping track of what jobs our guys go on and when /if they have turned in their paperwork. We have a sheet that we use in Excel(copy of the excel sheet is attached) that our guys are used to seeing the format of. We would like to keep the report as close to...

I have taken some classes in access and I am trying to make a couple of databases for my work. I am new so I will need help with what I am trying to accomplish. When I am not working I am playing with yarn or molten glass and taking care of the 4 legged kids(goats).