Is there a function similar to Dlookup in CR? I have a table similar to this:
ID STATUS TIME
2 IN 1/1/2009 8:00
2 OUT 1/1/2009 12:00
3 IN 1/1/2009 7:30
3 OUT 1/1/2009 11:45
4 IN 1/2/2009 9:15
4 OUT 1/2/2009 13:00
I have made a pivot that generates something like this:
ID IN OUT
2 1/1/2009 8:00...
Try bookmark your record before the sending the requery. This will allow you to go back to the record you were working before. Search the forum for it. I had the same problem.
I think Len is right. 3% per month is not bad at all. Maybe you all are referring to 3% annual. Historically, stocks will you give around 11% per year return...
I need some help making a form look like a pivot table; however I want to be able to change the data in the fields. I have a main table with 3 fields (Date,EmployeeID and AssignmentID). The last 2 fields are linked from the Employee and Assignment tables. Each Employee will be assigned something...