Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
A1ex037's latest activity
A
A1ex037
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...
Jan 7, 2021
A
A1ex037
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...
Jan 7, 2021
A
A1ex037
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.
Jan 7, 2021
A
A1ex037
posted the thread
Solved
Group salesproduct table by year and itemID?
in
Queries
.
Hello, I am trying to figure out how to make a query that will have total sales (by quantity) of every product by year? Table...
Jan 6, 2021
A
A1ex037
reacted to
The_Doc_Man's post
in the thread
Solved
Run-time error 2501
with
Like
.
The only other facet of this that could be machine-specific would be the references. You ARE, after all, calling subroutines that are...
Dec 16, 2020
A
A1ex037
reacted to
Minty's post
in the thread
Solved
Run-time error 2501
with
Like
.
So 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...
Dec 16, 2020
A
A1ex037
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...
Dec 16, 2020
A
A1ex037
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...
Dec 16, 2020
A
A1ex037
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...
Dec 15, 2020
A
A1ex037
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...
Dec 15, 2020
A
A1ex037
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...
Dec 15, 2020
A
A1ex037
posted the thread
Solved
Run-time error 2501
in
Reports
.
I'm having trouble with exporting report to a PDF file. This error happens only on newly installed PC and fresh installation of Office...
Dec 15, 2020
Home
Members
Top
Bottom