Search results for query: *

my report record source is a query- which stores the no of shipments.

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

but when i use the query method, i cannot show the detailed records in the report. Right? for example the report would not have fields like transport amt and rerated amount.

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

Thank you so much. it helped me a lot

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

Thank you so much it helped

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

i will work on that- but related to the same project, i want to export the report to Excel What is the easiest way to do that? I try to do this- File-> Export but in doing this i lose some of the formatting particularly the summary part of a report like sum or average- they come out as errors on...

how do i give you the SQL view of a report. i am really new to this . please help. thanks

how to create totals query and how to add it to reoord source. now the record source is different? if i change it doesn't it change the entire report- please help

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