Search results for query: *

Hello, I want to partially match the upload filename from another field. e.g: Field1: studentID 0023-ac02 Field2: upload filename will be like this: xyzsh-0023-ac02.ghure (upload filename with location) And how can I ensure that the upload filename included Field1 on the filename...

how to extract data combine with the parent datawindow and child datawindow? Thanks!

calculate days between different date and time: Please help me if anything wrong here: Problem is here: e.g, test_dt=3/22/2017, test_tm=10:50:00; dx_dt=3/24/2017, dx_tm=9:45:00 but the result is 3.00 (days) not 2.96(days) if( dx_tm>=test_tm, (daysafter( test_dt, dx_dt )) +...

Hi, Matt, Thanks for your replay but I didn't get it. Could you please give me more details about this matter? I really appreciate your kind help. Tong

Hello, I want to control subform rows by main form's question, e.g the question from parent form: How many people are involved in test? 4 (if answer is 4) column name: question1 the subform should automatically display 4 rows to available enter the data: First Name Last name city state...

Hello, Good morning! The following is my question: t1(text field) t1_unit (dropdown box) t2(text field) t2_unit (dropdown box) I want if t2 is not null then t2_unit=t1_unit otherwise t2_unit is empty I have the expression below but not work at this point... if(Not isnull(t2)...

The days could be calculated like this but how to get the expression: if time2>time1, (daysafter( date1, date2 )) + abs(secondsafter(time1, time2)/86400) if time2<time1, ((daysafter( date1, date2 )) + abs(secondsafter(time1, time2)/86400))-1 I tried but got the error messages... Thanks!

Thank you, Matt. Got it!

Hello, I am trying to calculator hours differences that combine with date and time e.g: date1(dd/mmm/yyyy) time1(hh:mm:ss) date2(dd/mmm/yyyy) time2(hh:mm:ss) hours difference= (date2 + time2) - (date1+time1) .....???? Thanks