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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.