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

    Show all when nothing selected from Combo Box????

    Here's the code: SELECT [x Apex Charge branch Query].Branch FROM [x Apex Charge branch Query] ORDER BY [Branch];
  2. Dineedshelp

    Show all when nothing selected from Combo Box????

    Hi I have classic combo boxes that look up various fields where users can make their selection and open the required report. What I can't find out, and I know this is possible as I have found it once before, is that if one of the combo boxes doesn't have anything in, i.e. the user doesn't...
  3. Dineedshelp

    SP delete group by blah!!!

    hi, stuck on the above - any ideas?
  4. Dineedshelp

    SP delete group by blah!!!

    just a thought, could I export these records, to another table, then find out the payroll number from a seperate table using the apexid? I know this can be done, but my skills in sql don't stretch that far!!!!
  5. Dineedshelp

    SP delete group by blah!!!

    Hi All, Thanks for the help so far, but even after the weekend and me trying everything I have come up with the following, and am hoping you might point me in the right direction of an answer!!! SELECT DISTINCT bookinguniqueid, ApexID, BookingReference, Location_Ref, --Payroll_No...
  6. Dineedshelp

    SP delete group by blah!!!

    tried the above, but I still have duplicates.............argh!!!!!!!!!!!
  7. Dineedshelp

    SP delete group by blah!!!

    don't have a date field, the only unique id is the bookinguniqueid field. Doesn't matter which record we keep, they are both the same. Thanks for your help so far!!!
  8. Dineedshelp

    SP delete group by blah!!!

    thanks, but your right, it deletes all the duplicate records, and the original records. I need to keep the orignal records, and just delete the duplicates. Does that make sense???
  9. Dineedshelp

    SP delete group by blah!!!

    Hi, Need to create a stored proc that will delete duplicate records held within a table. I can get the records out that I want to remove, but can't seem to put the right statements in the right place to delete just these rows!!! Please help!!!! So far: SELECT bookinguniqueid FROM...
  10. Dineedshelp

    Compare two HUGE Table's HELL!!!

    Hi PLEASE HELP!!!, I have two tables that are identical in everysense, apart from thier names. I have a dts that runs overnight to move the info from table a to table b. Tables a currently have 55578 records, table b 50986 records. I am losing 4592 records in the transfer. Is there any easy...
  11. Dineedshelp

    Join on a join on a join????!!!!!!

    Not working, comes back with the error: invalid name for locationref and wardref
  12. Dineedshelp

    Join on a join on a join????!!!!!!

    Hi, I have two tables that I need to join together, table a and table b. (Thats the easy bit!!!). Within table a and b I have three fields clientref, locationref, ward ref. All the records within my table have only one of either clientref, locationref, wardref. These are the only three columns...
  13. Dineedshelp

    Split a String

    Thank you!!!!!!!!
  14. Dineedshelp

    Split a String

    Hi, I don't know how I am going to explain this one easily but I will give it a go!!! I have a database linked to a sql database. Within this is a field that holds information that is set to hold the same information for every record, but might not as it isn't relevant. For example: Record 1...
  15. Dineedshelp

    String or binary data would be truncated?????!!!

    Thanks, from this I managed to sort the problem!!!
  16. Dineedshelp

    String or binary data would be truncated?????!!!

    Help!!! I have a stored procedure that has run with no problems, until now and it is returning the above error. I have increased the field sizes in the table tbut to know avail. Is there any way I can track down which record(s) are causing the problem? This is the error I receive: Server: Msg...
  17. Dineedshelp

    Convert DateTime String??!!??

    I have an access database linked to a sql server. Basically all the date in the SQL server are a datetime string. Is there anyway with access I can change these to just dates so I can compare varous dates being pulled accross? Please help!!! Its driving me mad!! Help files are as useful as a...
  18. Dineedshelp

    Concatenate ???!!!

    Thanks, its sorted, have added the locationcounty as I got rid of it for some reason!!!! Another lesson learnt for me!!!! Will get there some day!!!!
  19. Dineedshelp

    Concatenate ???!!!

    SELECT l.LocationReference , c.ClientUniqueReference, l.WardReference, l.ApexAccountCode, l.InvoiceContactName as 'ContactNames' , l.LocationName as 'Location_Company_Name', l.InvoiceName as 'LocationAddress1', l.InvoiceAddress1 as 'LocationAddress2' , l.InvoiceAddress2 as...
  20. Dineedshelp

    Concatenate ???!!!

    Hi, I have a stored procedure that was created for us, but is now causing me hell of a lot of problems!!!! I need to change various fields which I have managed to do, but the last one involves a sub query and I need to concatenate 2 fields which is doesn't seem to like. Is there anyway of...

Part and Inventory Search

Back
Top