Search results for query: *

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

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

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

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

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

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