Search results for query: *

My report has a field called as shipments besides other fields . There are hundreds of records. Now i want to see only those records where no of shipments is greater than say x value. I want the report to prompt the user to enter the minimium no of shipments and then display the records which...

ocity ostate dcity dstate carrier price A B C D X 1200 A B C D Y 1500 A B C D Z 2000 BASE Price for this lane is 2500 This is a sample taken out from my report. Now i want to calculate savings such that...

Ocity ostate transamt rated amt savings a b 56 43 13 a b 76 30 46 TOTAL 59 c d 40 20 20 c d 20 35 -15 Total 5 My report has hundreds of...

I have a table which has OriginSt OCity Dcity Dstate NoOfShipments A B C D 24 A B C D ? E F G H 34 E F G H ? There is a pattern of data here. Four fields in first two rows are same. i have...

There are two columns in my table and the corresponding report- Transport amount and Updated amount I want to see only those rows or records where transport amount is greater than updated amount. I tried using a query setting criteria to [transport amount]> [ sunrate amount] but this is not...

customer spellings in my table are messed up- the table has two million records and customers are spelt like this reprographics- this is the correct one reprog regrographic rerprographic reprographics there are many like these now when i summarize some data based on these spellings, all...

hi I am trying to convert a report in access to an excel file. How to do this. I tried exporting it but the summary fields like sum of a group appear in the next field as that of the field itself. Is there any other way doing it. like send object code in VB or something. i read about this in...

thread703-1299465 Can any help me with how to export or open up a report in MS excel in the same format Some body has mentioned send object macro or something

How to copy an Access report to Excel including the summary pary. This is a big report of 30000 records. Access is not allowing me to do so Please help

My boss wants to export a report to an excel format. Now the report is grouped by customer and some of the fields in each group has been added up inside the report. Now when i export this report to excel, the formatting goes wrong. The sums for each group are in adjacent fields eg...

We have a huge freight database - ms access in our organization and pretty much all the data is in one table- like about 1.3 million records. Three of us use that database and work with queries, forms and reports. When I say database, it is pretty much one table. My question, is it better to...

I want to do a calculated field inside a report. for example One of the group footers contains these fields 1)Total Transport Amt 2)Total Sunrate amount. Now i want to add the third field - Savings which is the difference between the above two fields. How can i do it in the group footer...

hi i have a report which has been grouped by origin city. There are few fields in the detail section like origin state, destination etc. i have also summarized a few fields by using sum function . While printing the report, the totals row is printed in a seperate(next) page as that of the...

hi My report has fields - customer, origin city, origin state and price. The report has been grouped by customers. Every group of records has been summarized by adding the price field using sum function. Now i want to sort the entire report not by customer field but by the result of the sum...