Recent content by Dineedshelp

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

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

hi, stuck on the above - any ideas?

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

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

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

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

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

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

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

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

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

Thank you!!!!!!!!

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

Thanks, from this I managed to sort the problem!!!