Recent content by wendy1967

Calculation - Form ~Scott, For the additional text boxes on the form, I've created a query that calculates Daily Pay, Premium Pay and Total Amount Pay. Then I've used the same query to develop the form. Therefore, the query is populated with all of the data that I need to create the...

The end-user has to input these fields: Start Date Time In Time Out For Example: Start Date: 12/01/2005 Time In: 10:00 pm Time Out: 6:00 pm The expected result should be 8 hours but right now it is giving -16. This is why I needed to add 24 to the first condition. The "" in 2 is needed...

In qryAddticket, I am trying to calculate two conditions (see Condition 1 & 2)However, I am having a problem on the first condition because it is adding 8 hours when it shouldn't. Can someone help to either fix my code or write a new one? Condition 1: If the day_of_wk is 1, calculate...

I am trying to type a code based on 1 & 2 criterias. However, I am having a problem on the first criteria because it is adding 8 hours when it shouldn't. Can someone help to either fix my code or write a new one? Thank you very much! Criteria 1: If the day_of_wk is 1, calculate...

Detailed Explanation Scott, The Pay table has these fields: Start Date, Time In, Time Out, Daily Rate and Overtime Rate The frmPay has these fields above plus: Daily Pay Overtime Pay Total Amount Pay These fields has a calculations and I want to store them to Pay table. Then I would like...

Scott, Thank you for your prompt reply. The calculations are based on payroll.

How do I store the data from the form to the table? Ex. I have some calculations on the form that I want store on the table so that I could develop a report using the information from the table.

I am trying to do this calculation but it doesn't work. It is yielding a negative number when the day_of_wk - "2". Can someone help? Thank you. pre: IIf([day_of_wk]="1",([time]-[reg_time])/60,IIf([time]<0,([time]-[reg_time])/60+24,IIf([day_of_wk]="2",([time])/60,IIf([time]<0,([time])/60+24))))