Search results for query: *

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...

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...

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.

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...

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...