filecrazy

Try creating 4 fields: Miles Entry, KM Entry, Miles Calculation and KM Caluculation. In your layout, format the two calculation fields without allowing entry into the field. Place the Miles Entry field over the Miles Calculation and do the same for the KM fields. Make sure all fields are formatted to be transparent. When you tab to Miles or KM, you will be allowed to enter into the Entry field and the calculated result will appear in the opposite Calculation field. Good luck.

Create the layout. Under Layout Setup, select "Print in x columns" - specify number of columns. Create a "Sub-summary when sorted by:" part in Layout mode. Be sure to sort by company. When creating the Sub-summary part, select "page break before each occurrence". Add the Employee field to the body. That should do it. Remember to sort by Company when running the report. Good luck.

If you're counting back only working days (Mon thru Fri), you should set up Case functions that count back a specified number of days depending on the day of the week of your original date. From what I understand, you're trying to set up at least three different date fields based on your original date. Try these calculations - be sure to set the calcualtion result to Date. Date Less 8 = Case(DayofWeek(Original Date)=1,Original Date-11,DayofWeek(Original Date)=2,Original Date-12,DayofWeek(Original Date)=3,Original Date-12,DayofWeek(Original Date)=4,Original Date-12,DayofWeek(Original Date)=5,Original Date-10,DayofWeek(Original Date)=6,Original Date-10,DayofWeek(Original Date)=7,Original Date-10) 4 working days prior to that = Case(DayofWeek(Original Date)=1,Original Date-17,DayofWeek(Original Date)=2,Original Date-18,DayofWeek(Original Date)=3,Original Date-18,DayofWeek(Original Date)=4,Original Date-16,DayofWeek(Original Date)=5,Original Date-16,DayofWeek(Original Date)=6,Original Date-16,DayofWeek(Original Date)=7,Original Date-16) 6 working days prior to that = Case(DayofWeek(Original Date)=1,Original Date-25,DayofWeek(Original Date)=2,Original Date-26,DayofWeek(Original Date)=3,Original Date-26,DayofWeek(Original Date)=4,Original Date-26,DayofWeek(Original Date)=5,Original Date-24,DayofWeek(Original Date)=6,Original Date-24,DayofWeek(Original Date)=7,Original Date-24) This solution doesn't account for holidays. Good luck.

You might want to try using a global field to store the last number used. Then your script could follow these steps: 1) Insert Calculated result of the global field + 1 (called Paste result in older versions) 2) Copy the new result and paste back to global field. Good luck.

Hi, Assuming you've already captured the number in the first field, you can create a calculation field that returns only the last 3 digits. Second field = Right(First field, 3) Good luck.

I've done this before using - you already have the Month field, Day field and Year field. Create a calculation field to concatenate the three text fields: Date (Text) = Month & "/" & Day & "/" & Year Make sure the result is set to Text Then create a second calculation field which will be the real date: Real Date = TextToDate(Date) Make sure the result is set to date Good luck.

I've been able to do this by creating 3 fields: Field 1 is a text field that auto-enters a serial number, increment by 1. Field 2 is a Calculation (Text result)that assigns a letter based on value of Field 1 - e.g. If(Field 1 >= 0 and Field 1 < 1000, "A", If(Field 1 >= 1000 and Field 1 < 2000, "B"....and so on. Field 3 is another Calculation with Text result: = Field 2 & Right(Field 1,3) Kind of a rough way to get there, but it's the only thing I can think of. Good luck.