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!

  • Congratulations Chriss Miller 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: chip12
  • Content: Threads
  • Order by date
  1. chip12

    Exporting Access To Excel

    I have a datasheet From Access that has approx 600,000 rows. I need to export that to at least 10 woorksheets in excel. Can Anyone supply code that will do that.I only use sql for querys and I not familiar where in Access to place programming code.Please supply that as well if possible. thanks...
  2. chip12

    Exporting ACCESS To Excel

    I ran a query that came back with 145,000 rows of information. I need to export that to excel. However Excel will only except 65,536 rows. I need some sort of workaround on this.
  3. chip12

    consecutive months

    I need to select all merchants via the merchant-id that have process for 12 consecutive months. Processing means that we have received payments via the merchant 's credit card. The processing information is held in the processing date column and is reported in days not months. I am not sure...
  4. chip12

    Days betweeen dates

    I have code that gives me that gives me the customer name,the purchase date, the date the customer paid out the contract completly but never defaulted before paying out. I am trying to find out the average numers of days between the 1st and 2nd contract purchase, 2nd and 3rd purchase...
  5. chip12

    Access SQl Query

    I need to group my data by month. The query I run gives the average of a select column of numbers but groups by days instead of months Below is my results. I need to group the averages by month instead of days. My code is simply not working Thanks in advance 6.762790698 1/2/2004 6.708717949...

Part and Inventory Search

Back
Top