Recent content by Perissos

text boxes on the report

TRANSFORM Sum(tblPayments.fldAmtPd) AS SumOffldAmtPd SELECT tblPayments.fldType FROM tblPayments GROUP BY tblPayments.fldType PIVOT Format([fldPostDate],"mmm-yy");

I have a report based on a crosstab query that I thought would be easy to do. It basically shows the information in the query and then puts a grand total at the bottom. Piece of cake until it asks for a percentage to be calculated off a portion of the detail. Example of Data on Report...

actually.. never mind. I've decided to go back to accounting. Thanks for all your help guys.

GalaxiomAtoHome, I tried doing this and ran into errors "user defined type not found" I am not sure I can work with ado libraries very well. I think the person I am developing for in on Access 2007,but don't know what OS they have. Can you suggest a good excel forum to get some help from? I...

Thank you for the input

lol.. I love that opinion. Unfortunately, I don't get to make the decisions...... yet For the moment I have it linked and it appears to work great. But I have that feeling like there is something I am not aware of that will cause an issue later.

I wanted to set it up in Access, they wanted it in Excel for the moment. Its going from Excel, to Access -reformatted -then back to Excel. I think its more of a time issue than anything at the moment

Just a quick question I have an Access database that when a button is clicked it will open an Excel spreadsheet for entry. When the entry is done it will call an Access function which will run some calculations and update a specific table stored in Access, then it will close the excel...

Well Simon... that is an extremely good question that I, unfortunately, don't know the answer to.

Would you be interested in a contract job since you know about this so well? and yes.. I am being serious

yeah.. just wish there was an easy way to convert the forms from one to the other without having to redo all the code that is A LOT of work. some of the code I used for creating the reports is sql. Will that be ok to use?

:( oh geez... I knew it sounded too easy. Gotta be a bright side to this, lol I may need lots of help!

Got it set up and it worked great until I got to the very end and it said I had to select a form to display when it goes to the website. My option to select a web display form is greyed out. Would you know why?

I had to go look found this note posted for someone elses question. Our SharePoint® Hosting has not been upgraded to the 2010 version as of yet Not sure when that was posted but I imagine that is the problem. I guess I will need to google sharepoint 2010 hosting