Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Diemesse
-
Sales reporting query for month and year
I changed to the left outer join, the query runs. I'll check the numbers to make sure I'm getting what I'm looking for. Thanks for the help, Rudy. I've ordered your book on Amazon. Dave- Diemesse
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Sales reporting query for month and year
OK, I might be getting closer. I am trying to get numbers both for the month, and for a running 12 months off of this query. Comparatively, this will tell us how we are doing this month compared to our average month within the last 12 months. Here's my SQL. Select * From (SELECT...- Diemesse
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Sales reporting query for month and year
You're right R937, probably wouldn't work. I've done light work in databases for 20 years, but never have been a huge SQL guy. I can get by with pretty simple queries most of the time. This was a working query in Delphi that I ported to Access for testing. (I stripped it down for posting to the...- Diemesse
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Sales reporting query for month and year
I'm writing a query that has me stumped. I work in Delphi, and am using an ADO query with Jet SQL (Access database). I need to know totals for the month in question, and also for the current year. How do I write a subquery to do this? I've tried: SELECT Q.Manufacturer, Sum(Q.QValue) AS...- Diemesse
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
