Monthly Archives: June 2021

Microsoft Access to Microsoft Word mailmerge – dates in wrong format

I was using data from a Microsoft Access query in a Microsoft Word mailmerge document the other day. However on returning dates they were in the American format rather than the UK one, although both Microsoft packages were showing my … Continue reading

Posted in Microsoft Access, Microsoft Access 2013, Microsoft Access 2016, Microsoft Word, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment

Microsoft Outlook – Ribbon not showing all icons

One morning I opened Microsoft Outlook to see only a condensed version of the ribbon I am used to seeing. I thought this may be something to do with a Microsoft upgrade but this isn’t really the case. The ribbon … Continue reading

Posted in Microsoft Office 365, Microsoft Outlook, Outlook 365 | Tagged , | Leave a comment

XLOOKUP – finding first or last value in data set

Yet another blog about the XLOOKUP function which is so powerful. Say I have a list of customers and I want to find the date of their first order or their last order. I have more than one order for … Continue reading

Posted in Excel 365 | Tagged , , | Leave a comment

XLOOKUP – finding the number of orders between two dates

We have already looked at using XLOOKUP to return data where columns are not in a contiguous order. There are many other uses of the XLOOKUP function. One could be to return the number of orders between two dates or … Continue reading

Posted in Excel 365 | Tagged , , | Leave a comment