I am hating the lack of functionality with DSUM in queries right now. I have several reports I need to run based off of information in several tables which are related. I also need to be able to show the information in forms. Therefore, I created a QUERY that properly filters the information that I need.
However, I need to run some subtotals using DSUM, which I know how to do. Yet, I would like to create some sort of 'autonumber' in the QUERY not TABLE in Microsoft Access so that I can better customize my DSUM formula. It is quite easy to do this in Excel, but I haven't figured out why it is harder than hell trying to subtotal crap and create customized autonumbers in Access.