Search results for query: *

Im not sure how to do a distinct query.

I am joining two tables together and my final product has many duplicate entries. How can I delete all of the duplicate entries. Thanks

I tried using XCOPY but it didnt work. I looked it up and the code should be something similar to XCOPY "N:\tam\ins.dbf", "C:\Horizon\ins.dbf" I am programming in visual basic within access and I get an error that says "sub or function not identified" and it highlights XCOPY. Any help on how...

I am trying to copy several files from a network to the C drive. I am currently using this code. FileCopy "N:\tam\ins.dbf", "C:\Horizon\ins.dbf" This works sometimes on some files but not on others. I am copying all the files by just changing the 'ins' to whatever the dbf file I am copying...

I have created a table in access and now I want to copy that table to the C drive as an individual DBF file. I am using visual basic in access and I can not figure out how to do this. Any help will be greatly appreciated. Thanks

I am trying to update code from an old program. The old code is SELECT ins.CNAME,ins.ATTN,ins.STREET,ins.CITY,ins.ST, ins.ZIP, policy.BCO, policy.POL, policy.EFF, policy.NEXP, ap3dbfb.YEAR,ap3dbfb.MAKE,ap3dbfb.MODEL, ap3dbfb.VIN, ap3dbfb.ST, carrier.CNAME, ins.REC INTO...

I tried DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY alias" also and it still gives me the same error. A RunSQL action requires an argumnet consisting of an SQL statement. Is there maybe some sort of library I need to use order by. This is the only part of my program...

I tried DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY rec" DoCmd.RunSQL "SELECT mid([rec],3,6) AS alias FROM driver ORDER BY driver.rec" neither one of these worked either. If anyone still has any ideas, please help. Thanks

I know that mid([rec],3,6) works in SQL because something similar works in many other areas of my program. Thanks for you help though

I am currently using this line of code to oder a table based on the values of rec. DoCmd.RunSQL "SELECT mid([rec],3,6) FROM driver ORDER BY rec " When I run this it gives me an error saying that what is inside the quotes is not an SQL statement. Can someone help me out and see what the...

I have a table that I need to add a column to. I have the column in another table. I basically need to copy it from the original table and put it on the end of the other table. When I do a SELECT INTO the data gets put at the bottom of the new column, I need the data to be at the top of the...