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 dencom 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: afeind
  • Content: Threads
  • Order by date
  1. afeind

    multiple rows to single row - top 3 results only

    I have 2 tables - student table, contact table Student table: student_id (key) fname lname Contact table: student_id (key) contact_id (key) fname lname phone Multiple contact records for each student id - max I have found is 10 records student_id, phone 11111, 5551212 11111, 5553434 11111...
  2. afeind

    Calculate Month Variance on Crosstab report

    I have a cross tab query that I am putting on a report. The months 1,2,3..12 print on the top. I need to calculate the difference in month 1 between 2005 & 2004, then month 2, etc. Here is my crosstab query below: TRANSFORM Sum([sales query 2004-2005].Quantity) AS SumOfQuantity SELECT [sales...

Part and Inventory Search

Back
Top