Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Tweenster
-
XL 2010 Pivot Table Refresh Error
Hi Skip, I did try your code, but I still get this error on re-opening: <?xml version="1.0" encoding="UTF-8" standalone="true"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error111400_02.xml</logFileName><summary>Errors were detected in file...- Tweenster
- Post #6
- Forum: Microsoft: Office
-
Return Value From The Most Recent Cell
Hi Skip, Thanks for your help, but I think the solution may be easier. All I need is the formula that I can put in the control source of the report header to look down the column and return the last value, not blank. Currently I have =Last([blue car]), but what I need is =Last([blue car])that...- Tweenster
- Post #15
- Forum: Microsoft: Office
-
Return Value From The Most Recent Cell
Car one can have 2 serial numbers, as items are moved around the fleet of cars, so to fix a widget on car 2, we borrow car 1's widget, what I need is the last time it was seen on car 1.- Tweenster
- Post #12
- Forum: Microsoft: Office
-
Return Value From The Most Recent Cell
The source data is an excel linked into a table with a record of maintenance done on a fleet of vehicles, I created a cross tab query with the report date and the serial number fields, and the items they are fitted to and fed that into a report, as above. On the report I grouped the widgets...- Tweenster
- Post #11
- Forum: Microsoft: Office
-
Return Value From The Most Recent Cell
Hi All, Thanks for your help so far, Chris was asking on behalf of me. The issue is.... I have a cross tab query with rows of Widgets, their fit dates, the column is the vehicle they are fitted to, and the value is the Serial number. This feeds into a report, please see below. The report is...- Tweenster
- Post #8
- Forum: Microsoft: Office
