Recent content by CCFL

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...

Yes, I have another system that runs a nightly sync to each user's machine and makes a copy for my server for me to use. It is not live.

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...

It worked perfectly, Thanks Again! I knew it possible but I had no idea what it was called or where to look. Here are some notes if anyone is like me and wondering how to create a crossetab query in Access 2007: On the Create tab, in the Other group, click Query Wizard. In the New Query...

Thanks, I will do right now.

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...

By the way, this is what I did I created a new field [text31] on the side hidden =CLng(24*60*CDate([time])) then created a total field under the daily entered hours =([text31]\60) The report looks perfect and only I know all the hidden stuff.

It worked ... It worked :) I don't know what I would do without you all. I owe you BIG time, Thanks

No, it does not work - it gives me a error.

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...

Table 1: BalanceDate (mm/dd/yyy format) and ServiceSales Table 2: DropDate (mm/dd/yyyy hh:mm:ss) and DropAmount I would like to report for a Date, ServiceSale, and DropAmount in one report. I get the date, ServiceSales then #DELETE or a blank screen in database view. I originally figured that...

Thanks Namliam, I tried a straight relationship and the query came back with no data. I don't understand your other options.

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. :)

----------------- YOU ARE THE BEST!!!!!! - It worked :)

This is what I tried adding to the query. 'HL' AS Exp1 INTO dbo_BalanceCash Drawer When used on a regular query, it added a column and inserted HL for each line. But when used on a UNION ALL query, I got an error message.