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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: justine1364
- Content: Threads
- Order by date
-
Adding amounts based on dates - combing "sum", "iif" and dat
I have a table with information on sales. I want to generate a table showing: - total sales per customer - sales per customer in the last 18 months The following code (which doesn't sum up anything) works: SELECT usdsales, iif(table1.orderdate>dateadd("d", -548, date()), usdsales) as...- justine1364
- Thread
- Replies: 13
- Forum: Microsoft: Access Queries and JET SQL
