Hi All, I hvae 3 fields Text51, Text52 and Text53. In the fields: Text51: P&I Credit Text52: =Sum(/) Text53: =Sum() I will like to sum up the total of this...

Hi All, I have 2 fields in a report. Invoice amount and Date Paid. The invoice amount will always be filled but not the Date Paid. How can i Sum Up the...

I have a crosstab query that compiles a list of expenses for the current month and the previous two months. After the first of next month, the 3 column...

I have a form with 6 pages on it, the form also has various command buttons, one of these command buttons i want to print a report based on the current record...

I have tried to show what my problem is in a "report" under here. PROJECT ID-NO PLANNED ACTUALLY ...

Hello All I have a number of reports with the OnNoData event set to Cancel = True. Normally these reports are opened individually via individual buttons on...

Hi again to all - Installed Time and Billing (2007) template. I've created a few records. When I go to print invoice from the project details screen, only...

I am currently using Access 2007. I want to create a macros to convert my Access reports to PDF. How would I go about doing that in 2007? Thank you.

Anybody know how to get an access report to include crop marks? Also, is there a way to print a border to each page?

Hi all, I created a form and hide the record navigator and I created a series of command button to navigate through the record at the fotter section of...

I am trying to produce a report that will advance to the next page (or column preferably) when it switches from the "a" names to the "b" name, and then to...

I need to be able to have the user print a specific record from a table ( and its related sub-records). I'd like them to be able to select the record from a...

I am struggling with launching reports from behind a Command button on a form where a query with a WHERE clause is involved. Launching the report from the...

Hello, I started this question in the queries group, and someone suggested using a report, however, after trying a lot of various things, I can't figure out...

Hello, Why is it that my reports look like they should in print preview; however, in the normal report view the formatiing is almost completely lost? Thanks.

Hi I have a report with sub reports which are hidden. I reference text boxes from the sub reports as follows rptReportName.Report!textboxname I would like to...

Is there a way to force a Group Section Event? I have a report with a group header and footer that have a hoizontal line in them, and when the last detail...

I have a 2-column report that is currently printing a uniform header at the top of each column, through the use of a "fake" grouping variable (thanks to the...

Since upgrading our users from Access 2000 runtime on Windows 2000 to Access 2007 runtime on XP Pro, we seem to have some problems when they run some code...

Hi All, Can tell me what is wrong with my below code? =Sum((IIf(IsNull(),0,(/)))+Sum()+Sum())