Search results

On my report ("Yesterday Report"), I have a field ("Total") that should always be equal to 5. If it is less than 5; someone didn't clock out and I need to manually go in a fix it. This report needs to be emails as a PDF attachment nightly to Amy. 1) I was able to use SendOption to create the...

Hey everybody reading this :) I have an Access 2007 database with a date form filter that has been runninng perfectly up until this morning. I did not do anything different (that I know of). It just stop working. Normally, I clicked on the report and the form pops up asking the dates for he...

This driving in crazy because I know it can be done but I figure it out. I have a query combining 3 different tables - each has the same field but different info, each table is labeled and connected by a date field. I know how to create a report that can list going the down the page. This is...

I have a report that list total hours worked per day. Does anyone know how to calculate the sum of hours workked. The automatic total feature only allows my count record and count value. Count Value gives me 00:00 everytime and I should be getting 57.65 (57h 39m) total hours worked. Hrs Worked...

I know you can build a relationship between 2 different tables using a date field. But is there a way to build it when; table1.balancedate uses mm/dd/yyyy and table2.dropamount uses mm/dd/yyyy hh:mm:ss. I am open to all suggestions. Thanks in advance. :)

I'm here in South Florida. I am new to this site and to Access 2007. I trying to created my own centralized reporting system but it is kicking me in the butt. :)