Search results

Hi I have a large database which runs various reports however i am struggling with the last bit to get this report working. Under each "Works Order" is a set of scrap which is associated with this batch. Instead of rows of data i would like to add all the "reason for scrap" to a single text...

The year and month are set from date despatched. The year and month is then linked to many other tables to gather data which is dependant on year and month. The yearandmonth combined field is the GROUP. Since the last post, i have managed to get this working through the same code posted...

Hi Thanks for your response - iv tried following this to the letter however it just doesn't seem to work - i have hundreds of queries and forms but its just this top n per group which is causing me some problems

Hi, I have a bit of an issue with this top N per group which i understand has been talked about on many occasions however i just cannot get this to work. The code i have entered is as follows: SELECT [1QryComplexityDelivery4].Year, [1QryComplexityDelivery4].Month...