Recent content by astrom33

I was doing the math wrong in my head. The output worked. You are 100% correct. The expression you gave me worked like a charm. Thank you VERY much.

Thanks!! That worked very well. However, on the few instances that the person worked more than 19.5 hours I would want it to deduct 1.5 hours. In other words an extra 30 minutes should be deducted for every 6.5 hours worked. Any ideas?

Hi everyone, I have a table with employee names, time in, time out, and total hours. In a query I want to create an expression (i.e., Total Hours After Meal Break) that will deduct a 30 minute meal break from any day where the total hours column is greater than or equal to 6.5, but less than...

I tried with the 0 instead of Null and got the same message.

I am sure I am doing something wrong, but I get the following error message: "Compile error. in query expression 'Sum(IIf(Day(Date) < 16, Hours, Null))' " Any ideas what I could be doing wrong.

Hi everyone. I have a table hundreds of thousands of entries showing employees' name, store number worked at, date worked, timein, and timeout. I made a query which gives me the name, store number, date, timein, timeout, and hours by employee as follows: ID Name StoreNumber...

Thank you both for your answers. Unfortunately, I don't know how to do either of the things you suggested. I will do some research into both your suggestions. Thank you very much for pointing me in the right direction.

I have two Tables: 1. PaymentsTbl: has four fields--TruckerID, Name, PaymentDate, Payment Amount. 2. TruckersTbl: has two fields--Name, TruckerID I want to create a form that updates the PaymentsTbl. In other words, the form would have the same exact fields as the PaymentsTbl. The...

The first thing I notices was that on table 2 have records repeating themselves at ID # 37. Is that supposed to be that way? Also how is the difference being calculated? A formula in the table? An expression? Sorry if these are stupid questions. I saw your form and it looks great. If I...

Thanks Scooterbug. I will test out the sample data and see what happens. As a sidenote, I left my desktop running one query all night. This morning I woke up and it had the results. So I will definitely not be trying that query again.

Thanks for the reply. Unfortunately, now I'm confused. My lack of experience is definitely showing. First, I don't know how to work with buttons. I can work with forms just a bit. Will I have to create a new table? FYI: The data that I have is set and no more data is being added. If...

here you go.

Let me create a dummy table with dummy information but with the same fields as the original db.

Ok. I tried the query of a query and I was able to get daily totals. However, I tried it on my desktop and it took a LOOOOOONG time. By long I mean a couple of hours. I then tried it on my dual-core laptop (3gb RAM) and it got me the results in maybe 30 minutes. Still a long time. I will...

Thanks. I'll try it out. As for the dates, unfortunately that is how the table was given to me and I am very hesitant to delete a field on a table. Although I know the date is also included in the txn_tm column as well.