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!

Register Log in
  • 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: *

  1. 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;
  2. ymeaga1n

    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...

Part and Inventory Search

Back
Top