Recent content by vasu1211

hi hi thanks e r the reply- but do i hav e to create seperate queries for calculating the sum for both the years. Can i doit by a single query? thanks

ost ocity dst dcity shipdate paid amt transport amt A B C D 1/1/07 7888 777 E F G H 2/3/07 733 887 I J K L 4/5/08 998 756 A B M N 5/1/08 778 697 E F...

automate can you please tell me how to automate the export with highligthing intact? Any code? thanks

i am trying to export a report into an exel file. I have used conditional formatting to highlight few records in the report. Now when i export it to exel t that formatting no longer exists. Is there a way to export a Access report to exel while still maintaing the formatting. Any code which...

report can u please tell me how to use filter property to set the criteria. for ex wgt<60

I have a field called as wgt in a report. I want to show only those records where the wgt < 60. Is there any way to set this criteria in the report. Please help

Original Table ozip dzip shipdate wgt Transport cost A B 12/1/07 20 450 C D 4/1/08 15 890 E F 9/1/08 78 750 A B 12/1/07 42 789 X Y...