vbacoder1962

Try using the below syntax: SELECT * FROM (SELECT sg_auf_artikel_history.SG_AUF_ARTIKEL_PK AS PK, sg_auf_artikel.ARTNR AS ART, sg_auf_artikel_history.AKTDAT AS DAT FROM sg_auf_artikel_history INNER JOIN sg_auf_artikel ON sg_auf_artikel_history.SG_AUF_ARTIKEL_PK = sg_auf_artikel.SG_AUF_ARTIKEL_PK GROUP BY sg_auf_artikel_history.SG_AUF_ARTIKEL_PK, sg_auf_artikel.ARTNR, sg_auf_artikel_history.AKTDAT) WHERE #2013-04-01# < DATE < #2013-04-30# ORDER BY ART, DAT;

This was a query raised by one of a forum members at another site, where he had a worksheet filled with random numbers, and I have already answered that query [at my post here](https://vbacoder1962.wordpress.com/2019/07/15/extracting-cell-phone-numbers-from-random-strings-of-variable-length/). You may go through that post and read the logic behind the code.