Recent content by Donzi255

I received an error using currentfieldvalue, "Date Time is Required here"

Perfect !!! That was it !!! Although, I did have to substitute my end_date field with currentfieldvalue. Thank You lbass !!! Donzi255

Yes, all the fields in the row to appear RED. And, I do want the next 90 days from current month end.

Sorry for the confusion. I do not want all records in the detail section red. I only want the record in red, if it's within the specified date range. I used Aged61to90days because it is in the drop down list.

I re-checked and made a mistake. I am printing only the requested end date field in red. I highlighted all other fields format object and created the formula in the Formula workshop - current formula:Font If {Asset_Detail.Asset_End_Dat} = Aged61To90Days then crRed else defaultattribute

Althought this worked, it turned all records to red. So, I'll explain further. I want to produce a report of all expiring assets in the next 3 years by month end date. I want to alert the manager of his employee assets expiring in the next 3 months with color change. All other assets will be...

I would like to print the output of query in a different color (Red) when the an expiry date field is within the next 3 months. Field names are from Asset Table & Employee Table: Last Name, 1stName; Model, s/n, Expiry date. If expiry date = 11/30/08 - January 31, 2009 print Expiry Date in RED...

Yes, assumptions correct. Asset_Type table & Employee table linked by emp_no. Yes, my selection formula is {asset.asset_type} in ['B','C','L']. I grouped by last name and inserted a distinct count. This resulted in the employee with 3 assets and the employee with 2 assets and the employee with...

I have a field called asset_type. The field can be PDA (B); PC (C); or Laptop (L). I would like to see only the employees with all (3) asset types. My current selction shows me employees with just a PC, or just laptop or PC and laptop and all 3. How do I modify my selction to see employees...