Search results for query: *

I will give it a shot. Thanks for the help

I was able to create a button on the table and get the highlighted data to export to a spread sheet. The only things that i need assistance on is making sure the data goes on a pre determined sheet within the excel spread sheet and deleating the highlighted data.

How would i do it in VB???

I am not a VBA person at all. As it was explained to me by the person i am trying to help out. The Excel spread sheet will always be the same name but the exported data would go to a specified sheet. I want to be able to highlight the data on the access table and have it export to that sheet on...

I hope somone can help me. I want to be able to make a custom button to export a table in access to a specified excel stread sheet. The spread sheet had multiple sheets and want it to go into one of them. How can i do this.

Thanks for all your help. :-)

That worked out great. Thanks to all who helped me. One more question if i may. how can i add a custom button to a table that will export the highlighted selection and export out to an excel spread sheet. The spread sheet could be an existing one with data in it.

I will give that a try and let you know

That worked. If i understand everything, if i want to show a total for the sub total, i do the same proceedure? or what would be the command for summing the sub total for a new field called total? i can add a text box in the report footer to show the total amount.

After the query, i want to create a report. i will have multiple entries. How can i get the subtotal to show for each entry? I want to show a Total at the bottom that sums all the sub total fields

I have a table with several fields. one is quantity and another is cost and a final is sub total. I want to multiply the nembers in the quantity field and cost field and have it display in another field called sub total on the same table. How do i do this????? and where do i do this? ex...