Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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

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