Recent content by Samantha

Thanks, you made me think more on manipulating it that way (whiting out the values). I took your idea and just duplicated two of the conditional formatting rules so I don't white out my dates at the top and I don't need todays red line all the way down the page. It gives me the desired output...

Yes, it would be better on a formula level because the overall use is it to total the men at the bottom of the form. I would need to manipulate it in the same way the conditional formatting excludes weekend based on my cell value string strWkend on the second tab. Once warm weather hits we will...

Yes, partially. That is one of my issues, although values for today (sunday) in the chart should not populate either. The other is a formula in the conditional formatting - getting the actual work days to turn dark blue within the range. I am now suspecting that because my end date is a...

Hello, I have been driving myself insane for the better part of the day trying to manipulate this gantt chart. The conditional formatting is not cooperating as I would expect. I am determining calendar days by listing workdays * manpower and then eliminating weekends and holidays, That part is...

Hey Guys, consumer here. I would hate to see this resource disappear for sure. YouTube would probably drive-up participation. I am an office manager, construction industry, in the US started in the small business sector and while we have grown into a larger corporation who can pay Salesforce...

Thats exactly the problem! Thank you for your help!

Time to waive my white flag and give it to the pros ;). I have a continuous form that I am trying to flag every project red that we are only working off a "Notice to Proceed" and the contract value exceeds $5000. [ContractStatus] should display with red text. I've highlighted the record which...

Oh no I must not have refreshed my screen in some time. I will take a look - you don't know how much time and frustration you've already saved me. The lady that normally does this in excel, manually, quit and now I get the pleasure of making sure everyone gets paid. Last Monday was a disaster...

Pat, I tackled the easiest parts first, which happens to be backwards. #3 - Was a simple resolution went with InStr; and I saw a similar example but kept trying to throw in a * for good measure. #2 - again I was working backwards and was trying to pull in a total before the crosstab qry...

Good morning, I have been working to create a solution to get our payroll from our time keeping app, build a report to review, and prepare the data for upload to our payroll processing company. My specific questions today (or this moment): 1.) On the report when I replaced December dates...

Pat - sorry to throw you for a loop. PTO is not included in the calcs but otherwise its simply anything over 40. We are a federal contractor, comply with Beacon Davis (certified payroll) private corp- non-union in Maryland. Tell me your in California? They are their own country :-) with lots...

Thanks for your time and direction, I will try and dig into this!

Hello, Thanks for all the replies! Hope everyone enjoyed the holidays! I had to take some time off and not check my emails. I am going to try and effectively respond. Love programmers! You're all so detailed oriented and want to get into the nitty gritty. The legal OT rules in my state is...

Thank you for all of the replies! I am attaching a pdf to try and illustrate/further explain in hopes of direction. Multiple employees, over weekly pay period Mon - Sun. I could create a feed to access through a link to an excel data sheet. I don't need access to remember/store the data so...

Hello, I want to determine if Access can automate some of my Payroll woahs. So my example table is what pulls out of a timekeeping app. The first column is an employee ID; so we are looking at one person. The last two rows from 12/01 was originally one line that I have manually split into...