A1ex037's latest activity
-
AA1ex037 reacted to arnelgp's post in the thread Solved Group salesproduct table by year and itemID? with
Like.
SELECT Year(Sales.SaleDate) As [Year], SalesProduct.ItemID, Sum(SalesProduct.Quantity) As [Total Sales] FROM SalesProduct Inner... -
AA1ex037 reacted to plog's post in the thread Solved Group salesproduct table by year and itemID? with Like.
What you've described is achievable via a cross-tab query...
-
AA1ex037 replied to the thread Solved Group salesproduct table by year and itemID?.Nice! That is exactly what I was looking for. Thank you @plog and @arnelgp for your answers.
-
AHello, I am trying to figure out how to make a query that will have total sales (by quantity) of every product by year? Table...
-
AThe only other facet of this that could be machine-specific would be the references. You ARE, after all, calling subroutines that are...
-
ASo if it's not the path and is the actual filename, can you give us some example filenames that fail? BTW I would permanently keep the...
-
AA1ex037 replied to the thread Solved Run-time error 2501.Yes, same languages, same defaults (english). I will remove 2nd language now and see if it changes anything. Tried that, nothing...
-
AA1ex037 replied to the thread Solved Run-time error 2501.I did that few days ago (honestly, didn't know that the order matters). Everything looks completely the same. I have compared all 3...
-
AA1ex037 replied to the thread Solved Run-time error 2501.Yes, the computer is freshly installed. It's a nice thought, but everything has been done and configured properly. I have checked for...
-
AA1ex037 replied to the thread Solved Run-time error 2501.I have tested each line separately, paths are correct. I have a bug at the back of my head that I had to do something on machine when it...
-
AA1ex037 replied to the thread Solved Run-time error 2501.Thank you for fast replies. Directories are empty. Nothing inside, reportK subfolder is also there (with appropriate permissions). Same...
-
AI'm having trouble with exporting report to a PDF file. This error happens only on newly installed PC and fresh installation of Office...