Recent content by showdebola

Hi guys, I am trying to run a query that gives me the top names of each category. This query is getting the data from another query that here i call QrySpreadReport. Here is the query. SELECT [S&P Rating].[IdS&Prating], [S&P Rating].[S&P Rating], QrySpreadReport.EntityName, QrySpreadReport.Mid...

Hi everyone, i am quite a begginer at this so sorry for the simple question I am running a access query from a vba code. IN the vba code I am writing the sql command. I am getting the criteria for the sql code (WHERE command) from a number of combo boxes in a form. The whole thing works...