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 Mike Lewis 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: bai73
  • Order by date
  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

Part and Inventory Search

Back
Top