September 4, 200817 yr may be related to: http://fmforums.com/forum/showtopic.php?tid/197715/post/new/#NEW I have a db that will show user clock times, current week displayed: Mon-Fri, up to 4 clock-in/outs and then weekly totals per month... This is what it looks like I need to display current weeks daily times and then sum of hours per week/per month My table for hours looks like: nameUserName;timeIn;timeOut;date multiple instances of username exist in this table for each record is a clock-in/out interval so I could have: jsmith01;8/1/08 8:00:00 AM; 8/1/08 9:30:00 AM; 8/1/08 jsmith01;8/1/08 9:45:00 AM; 8/1/08 11:30:00 AM; 8/1/08 etc Finally, my question is: can a merge field hold formulas or functions or SQL Statements, such as display time where day of date = Monday for specific user... perhaps I am over complicating it... Basically I need to call current week's times by days of the week jeez this is not making sense to me... Thanks for your help!!! Edited September 4, 200817 yr by Guest had to add some content
Create an account or sign in to comment