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, sorry it has taken awhile to get back here. I have created a small sample database as it was complicated trying to strip down the original. The attached has enough dummy data to be effective. In this DB I have created two queries. The first shows the top 5 agents by the State of VIC...

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...