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 derfloh 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. wayneswc

    Select Views

    It helped perfectly...thanks a lot I can go make a coffee now instead of spending an hour typing!!!
  2. wayneswc

    Select Views

    Hi I want to create a list of my views for a colleague and type a few notes explaining what each one does. I have around a 100 views and rather than type them all out i was wondering if there is a select statement i can use to pull them out or another way of copying the list of view names Thanks
  3. wayneswc

    Order of Conthist

    Hi Rich I don't think i can, I don't think i explained myself to well as to the end result i was trying to achieve, I'll try to be brief My Database has 60,000 records with over 500,000 entries in conthist. I have 40 agents using the database a number of these agents could be contacting the...
  4. wayneswc

    Order of Conthist

    Hi I've have always believed that as each historical activity is added to a contact record in Goldmine it is given a higher recid. So i have always written my "latest history" reports with a "select * from conthist where recid in ( select max (recid)..............." type query I have...
  5. wayneswc

    1 Table 3 Forms

    Thanks Guy's I can't access the base at the moment, but as soon as i get a chance I will. When I said the table stored customer detail, that wasn't quite correct, It only holds the customer Reference number, contact details are stored in a different table Wayne
  6. wayneswc

    1 Table 3 Forms

    Hi I have a large table with roughly 110 fields (large for me anyway), the table contains customer details and stores unique code numbers for products they have bought, so they all have a one to one realtionship, which is why i thought it easier to have one table. The data is displayed on...
  7. wayneswc

    Goldmine SQL Select query

    Hi I am working on GM V6.0, my problem sounds easy, but is proving to me more difficult, for me at least, than i thought. I want to create a report that lists all of our prospects and tells me when the were last called and when they are next scheduled to be called. I have got so far, and have...

Part and Inventory Search

Back
Top