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

    Update Query Based on Latest Dates

    Thanks guys - will give both suggestions a try (the database is Ingres by the way). Cheers
  2. lambic

    Update Query Based on Latest Dates

    Hi, I have an to write an update query, based on dates, which I can't quite figure out. The details are: Table A: AccountID DateFrom DateTo Value Table B: AccountID DateFrom DateTo Value What I need to do is update Table A Value with the Value from Table B where the AccountID's match and the...
  3. lambic

    Closing up rows in detail section

    Thanks Synapsevampire. Have managed to sort it now with your help. Cheers
  4. lambic

    Closing up rows in detail section

    Hi, Im using Crystal 10 with a SQL Server 2000 Database. I have a table which contains one or more records for a given record ID field. Each record has address line columns, Address1 - Address4, and 3 boolean fields to indicate what type of address it is, Type1, Type2 or Type3. The address can...
  5. lambic

    Update query problem

    Have managed to sort it out - with your help. Thanks for taking the time out to help guys. Cheers!
  6. lambic

    Update query problem

    Hi, I am trying to write an update query without much success! I have the following 2 tables: TABLE_A Account_ID Sub_Account_ID Sub_Account_Adj Issue_Flag TABLE_B Account_ID What I need to do is set the Issue_Required_Flag from 0 to 1 in TABLE_A where the Account_ID exists in TABLE_B, but...
  7. lambic

    Auto fill range of cells in MS Excel 2000

    Thanks guys. I think the macro code would be ideal, the serial number is just a number so should be fine. I'll give it a go. Thanks again
  8. lambic

    Auto fill range of cells in MS Excel 2000

    Hi there, I was hoping somebody may have some advice on the following: I want a user to be able to run a batch of mail merge labels in MS Word 2000. The labels contain a sequential numeric code which increments by 1 on each label. I can achieve this easily emough using Excel as a data source...
  9. lambic

    Export Object Data Failing In DTS

    Hi, No, I haven't checked that option. I just tried the export with it checked, but it failed with a 'failed to set user permission' error. Basically I just want to copy the data into a replica database on a weekly basis, for reporting purposes. I'm not using the SQL replication function as I...
  10. lambic

    Export Object Data Failing In DTS

    Hi, In SQL server 2000 - I'm attempting to copy data from tables in database A to database B. Database B is an exact copy of database A and is on the same server. However, if I use the DTS Import/Export Wizard, choosing 'Copy objects and data..' and 'Copy data - replace existing data' the copy...
  11. lambic

    Insert into a table where record doesn't already exist

    Thanks guys - problem sorted now. Cheers!
  12. lambic

    Insert into a table where record doesn't already exist

    Thanks to the both of you - will give it a try Cheers!
  13. lambic

    Insert into a table where record doesn't already exist

    Hi, Thanks for that guys. I didn't explain propertly that what I don't want to insert into the table is a record that has the same account_no & reference_no combination as a previously inserted record. The second insert can pick up the same account_no, but I only want to insert it if the...
  14. lambic

    Insert into a table where record doesn't already exist

    Hi, I have a problem with an insert, basically I've populated a table (say table_a) with records based on one criteria, and have to then insert records into table_a based on another criteria, but only if they don't already exist in table_a. E.g. insert into table_a (account_no, reference_no...
  15. lambic

    Formatting cards 4 on a page

    Doh! My mistake - sorry!
  16. lambic

    Formatting cards 4 on a page

    Hi lbass, Thanks again for your help. I've done what you suggested & created a SQL command to get the total record count (which works fine), then embedded that into the sort formula. However, it now doesn't work for some reason (data is now in same order as the table). My sort formula is...
  17. lambic

    Formatting cards 4 on a page

    Thanks very much for that lbass, it works great. Do you know if its possible to dynamicaly calculate the number of pages in the sort formula, so that if there are a varying number of records when the report is run, I don't have to edit the sort forumla? Many Thanks
  18. lambic

    Formatting cards 4 on a page

    Hi, I have a requirement to produce some address cards using Crystal Reports 10 Professional, using data from a MS SQL Server 2000 database. The cards need to be printed 4 up on A4 in landscape, which I have set up with no problem, however they need to look someting like this (example using 12...
  19. lambic

    How To Load An Array From A CSV File

    Hi, Basically I need to write a script which will take a fixed length text file, read each record & split it at a certain point, adding a character looked up from the array (the subscript will be a field in the record), then joining the split record again and outputing to a new file. Example...
  20. lambic

    How To Load An Array From A CSV File

    Thanks. I've realised that I've posted in the wrong forum, as I'm using NAWK to develop this script! I'll repost in the correct forum.... Sorry guys.

Part and Inventory Search

Back
Top