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!
Recent content by ymeaga1n
-
Subquery to pull data from same table at earlier time
Wow, I hit submit by accident...now I don't know how to modify it. I made a mistake in the code I posted, it is supposed to be... SELECT data_bdat AS [Sales Date], data_sls AS [Total Sales], (select data_sls from table1 where data_bdat = data_bdat - 364) AS [Last Year Sales] FROM table1;- ymeaga1n
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Subquery to pull data from same table at earlier time
I need some help guys. I'm pretty new to SQL and I don't know if what I'm trying to do is allowed. I'm running a query on an Access datatable. I want query to display 3 columns to me. Column 1 = Date. Column 2 = Total Sales on that date. Column 3 = Total Sales from year ago. I ran the...- ymeaga1n
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
