Search results

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

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