Search results for query: *

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

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

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

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

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

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

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