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

    comparing the two sets of data

    There are two different tables as shown below . The first table is for mode L. The second table is for mode T. Now i want to compare cost/lb for every wgt range- wgt range could be 1)<500 2)>500 and <1000 3)>1000 First Table - Ost ocity dstate dcity Mode Wgt Cost/lb KY hop IN...
  2. subs1678

    exporting access into excel

    i am trying to export a report which has summary like sum and count into Excel. But the summary portion in excel gets messed up. The summary portion goes into adjacent clumns. IS there any way to export the report into excel such that data is aligned correctly. thanks
  3. subs1678

    Access to excel

    when i convert access report to excel, my summarized data like sum, count go to columns adjacent to where they should be. Is there any way to solve this problem.
  4. subs1678

    Access to excel

    is there any way to automate the export of a Access report to excel. for example if there is a button on the report, and on clicking the button, the report should be converted to excel format. Is there any way to create this format? Please help if there is a macro or some program
  5. subs1678

    clean up the database

    i am using Access and believe me or not, one table which is called freight table has right now 1.4 million records ( 2006 and 2007 YTD). Each record has origin st, origin city, destn st, destn city, paid amt, transport amt, weight, paid date, ship date, consignee, shipper,client, zip...
  6. subs1678

    clean up the database

    thanks for the reply-lestatdelioncourt . Could you please help me with method no 3. I am quite new to this database. I would appreciate if you could tell me step by step thanks a lot in advance
  7. subs1678

    clean up the database

    i have a freight database which has a field called as consignee. This field has millions of records and has mispellings all the way since the data is typed manually by diff people. for example remou is spelt as rem, remo, rems etc. Is there a easier way to correct all the spellings at once. I...
  8. subs1678

    enter the data correctly

    can you please tell me how to set up a combo box control in a form. and how to correct these spellings thks
  9. subs1678

    enter the data correctly

    my company is using forms to enter data into one of our main tables. Now a field called as consignee is always messed up with misspelling. How to make sure that the information entered through forms is correct.are there any look up lists that can be used. Is there any easier way to correct these...
  10. subs1678

    improving the access database

    I appreciate all the feedback but this is a transactional database. So i donot understand how is it possible to link the data. Every field like paid amt, transport amt, fuel amount , client(who ordered the shipment) , consignee( one who received it) are all linked to four fields- origin st...
  11. subs1678

    improving the access database

    Many of the fields like client, consignee, fuel surchareg,detention charge, mode, carrier are specific to a particular transaction i.e origin to destination. So a transaction table could have fields like origin city, origin st, origin zip,destination city, destn state, destn zip,shipdate,paid...
  12. subs1678

    improving the access database

    Thanks for the reply Joe- one clarification please- in this table we have field called as consignee. Consignee names are all over the place- huge spelling mistakes as you pointed out. but how do we avoid these spelling mistakes if we put this field in a different table? with what other fields...
  13. subs1678

    improving the access database

    i have a transportation database with the following fields Origin st, Origin City, Destn St, Destn City, Zip, paid amt, trans amt, keyID( one who enters all the info), fuel surcharge, mode, carrier, client, consignee, desc1, desc2, desc3( all the desc columns are most of the empty), weight...

Part and Inventory Search

Back
Top