Merge Fields and formulas?

[pcjimenez]

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, 2008 by Guest
had to add some content