Hello,
Now I admit my skills in VBA are novice, but I can learn fast. I know the basics, but this is beyond me right now.
We are trying to make a process more effecient, and we have queries that require us to first get a total dollar amount and then the total number of records for those dollar amounts.
We then need to get a list of the top 50 records, and put those into an excel sheet.
My first goal is to get the total count of records in the query into a summary form without running this query, but based upon the criteria in the query. I want to do this using VBA.
Query SQL Statement bellow
SELECT Daily_file_FL.HI, Sum(Daily_file_FL.[Submitted Amount]) AS [SumOfSubmitted Amount]
FROM Daily_file_FL
GROUP BY Daily_file_FL.HI
ORDER BY Sum(Daily_file_FL.[Submitted Amount]) DESC;
I have a summary form with unbound text boxes that will populate OnOpen, once I have the VBA correct.
I have played around with Dcount from the table Daily_file_FL but I'm not sure if I can use a SQL statement in the criteria section, which would be awesome. I have no experience writing SQL statements in VBA.
All help is apprecieated. If more info needed please let me know!
Now I admit my skills in VBA are novice, but I can learn fast. I know the basics, but this is beyond me right now.
We are trying to make a process more effecient, and we have queries that require us to first get a total dollar amount and then the total number of records for those dollar amounts.
We then need to get a list of the top 50 records, and put those into an excel sheet.
My first goal is to get the total count of records in the query into a summary form without running this query, but based upon the criteria in the query. I want to do this using VBA.
Query SQL Statement bellow
SELECT Daily_file_FL.HI, Sum(Daily_file_FL.[Submitted Amount]) AS [SumOfSubmitted Amount]
FROM Daily_file_FL
GROUP BY Daily_file_FL.HI
ORDER BY Sum(Daily_file_FL.[Submitted Amount]) DESC;
I have a summary form with unbound text boxes that will populate OnOpen, once I have the VBA correct.
I have played around with Dcount from the table Daily_file_FL but I'm not sure if I can use a SQL statement in the criteria section, which would be awesome. I have no experience writing SQL statements in VBA.
All help is apprecieated. If more info needed please let me know!