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 bkrike 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 bai73

  1. bai73

    sql statement to sum results over months and years

    Hello PHV, I have tried this code and no error message is coming. Since I am new to this Transform type of sql statement, am unable to understand why any results are not being retrieved from the Access database which has 5 years of entries in it. Do this statement further needs to set any record...
  2. bai73

    sql statement to sum results over months and years

    Hello PVH, I would try to write in detail about my problem..I have a date wise sales data for the last four years..I want to get a report where months are the columns and years as the rows like below: [Year]Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 2004 ? ? ? ? ? ? ...
  3. bai73

    sql statement to sum results over months and years

    I have date wise results in a database and would like to sort them out into months and years and also over the respective year in a table form. I would appreciate the help in writing a sql statement for a Access database. Thanks!
  4. bai73

    retrieving random recordset in frontpage 2002

    I want to retrieve random recordsets from the access database by using frontpage 2002. Can any body help in writing the sql select statement? Thanks
See more

Part and Inventory Search

Back
Top