InfoPath Dev

What I’ve done is created an InfoPath expense report where each month, our folks can go to our SharePoint site, open up an expense report, fill it out, hit Submit and it automatically sends it as an email to me as well as updates our SharePoint site with a copy of it.   What I’d like for it to do is have the capability to take all ...

Not what I'm looking for.  Maybe I need to build an Access database, link the InfoPath file to it so it can compile and calculate all of the numbers I need at once.  Thanks.

Yes, the first option is what I'm looking for.  Where can I find instructions on how to do something like that?  I want it to be able to take several submitted expense reports for a particular month and put it all together in one report so I don't have to open each one, add up all the numbers and risk making a mistake...

Am still waiting on a response to my question, thanks.

Hey warrtalon, Thanks for your response.  What I've done is created an InfoPath form for my colleagues to use on a monthly basis and when they submit the report, it's updated to a SharePoint site so that we at least have a record of it.  However, we have a lot of people who submit reports on a monthly basis, so it'd be nice ...

It works great!  Thanks Patrick!

Hey Patrick, This worked perfectly.  Thanks!  One more question - when I was doing the Fx for the SharePoint Library Submit data connection, I decided to do a concat so that the file name is obtaining information from three metadata fields on the form itself.  How can I add a dash and a space to the formula itself?  So ...

Does InfoPath have the capability to take information from several forms and put it all in one clean form?  For example: Bob has an expense report for January 2011 - $100 for lodging, $50 for meals and $75 for transportation. Susan has an expense report for January 2011 - $150 for lodging and $100 for meals. Jack has an expense ...

Thanks.  Where can I find some instructions on how to do so?

I started using the Expense Report sample form that's on InfoPath 2007 and have modified it to my liking.  I'm stuck on one thing and was wondering if someone could help.  I'd like to have the Submit button have the capability to look at certain metadata that's on the form itself (i.e. - Joe Smith is filling out an ...