| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 43348 | 2004-03-11 21:59:00 | Excel iteration? | tituscanby (5391) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 221826 | 2004-03-11 21:59:00 | I have a unique ID for any property on an Access database. Some properties have been visited more than once(some up to 8/9 times) to check for faults. The dates for each visit are recorded. If a property has, say 3 faults then the date is shown 3 times. The faults are the same(99.9%) between each visit. However I only require the number of faults for the last time(date) the property was visited. This information has been transferred to an Excell spreadsheet but I need the formula/equation to get rid of the 'redundant' date info. Is there a solution for this? Hoping. JW |
tituscanby (5391) | ||
| 221827 | 2004-03-11 22:37:00 | I would suggest you filter the data before it gets to Excel. Create an Access query that only selects the latest date record for each property ids and use those results. HTH Tony Bacon |
tbacon_nz (865) | ||
| 221828 | 2004-03-12 00:42:00 | Will have a go. Thanks Tony. |
tituscanby (5391) | ||
| 1 | |||||