Hi arnelgp,
Thank you so much for this, your solution is exactly what I wanted and done so elegantly, I can easily use this method with confidence as my data will not risk corruption via human error.
To everyone else who has contributed a big thank you for your time. (y)(y)(y)(y)
Hi folks, thank you for your replies, I'm attaching an Excel sheet exported from a table I created and tidied up that needs the "no data" lines deleting. As you will see the dates are contiguous and naturally include weekends which are highly likely to not have data. Naturally, customers don't...
Hi, I have a shed load of tables to import from Excel because a user has seriously overused Excel to do a database's job (yet again :oops:). The individual sheets all have every date as place holders for the formulas so the rows with only a date are of course irrelevant in access. I need to...
I'm an EngTech MIET, used to work in British Aerospace but now a Field Service Engineer in Industrial Food Machinery. I last worked with Access in 2009 but now find the need to re-acquaint myself, lots of head scratching but surprised how much I do remember even though Access has morphed...