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

    How to compare data by month

    Thanks for the help Paul. It works perfectly and my data is formatted just the way I wanted it. Marshall
  2. Marshall2000

    How to compare data by month

    Sorry but that didn't work. I still have the month showing twice. The first time shows 2002 data in the h1 fields and the second pass shows the 2003 data in the cy fields as shown. Month hiamount cyamount h1count cycount January 1000.00 1200.00 February 1233.00...
  3. Marshall2000

    How to compare data by month

    SELECT [All retail by year].account, [All retail by year].name, [All retail by year].date, [All retail by year].CYamount, [All retail by year].CYstatunits, [All retail by year].CYCount, [All retail by year].H1amount, [All retail by year].H1statunits, [All retail by year].H1Count FROM [All retail...
  4. Marshall2000

    How to compare data by month

    I am attempting to create a report that compares data from 2002 to 2003 by month. I have a query that has the 2002 data with field names h1amount, h1count. it also has 2003 data in fieds cyamount and cycount. I want to compare the data side by side by month. Example Month hiamount...

Part and Inventory Search

Back
Top