Search results

Hi, I have a database where the user can click on a button and it will export a table of data to a set location. The user is using a runtime Access 07 version. The code I am using is: DoCmd.TransferSpreadsheet acExport, 10, "T-History", "c:\database\agthistory.xlsx", -1 The issue is...

Hi, I want to get the sum of sales of the top 5 best agents by state. I have been able to do the following, however, this only gives me the state of "vic". I want it to show all states. SELECT TOP 5 filedata.Debtor, Debtors.FullName, Sum(filedata.NetTotal) AS SumOfNetTotal, Debtors.State...