Search results

Help :confused: I know it's not normally done but I have a one page report that requires the total (sum) of a field - [EDS_total] - be at the bottom of the page. I found a post on Microsoft's site but it is for a sum on every page's footer and it is for MS Access 2003. I am using MS Access...

From eRed the Noobe :-) I have a report that I am trying to save as a PDF using DoCmd.OutputTo This code properly saves the report: DoCmd.OutputTo acOutputReport, "LTCFarNF", acFormatPDF, "M:\ARMGR\Reports\" & Me.ltcfname.Value & Chr(34) & ".pdf", True However, I need to filter the report...

I need to create an Aging Report. The clients have two types of dollar amounts due (FIELDS: "NAME", "TYPE", "AMT_DUE", "DUE_DATE" ). The first is a single line item, one time charge (TYPE=4000), The second is a series of amounts in the form of monthly payments (TYPE = 5000). I...

Please help :confused: This works DoCmd.OpenReport "ReportName", acViewPreview, , "[ReportName].[FieldID]=" & Me.FieldID and this works DoCmd.OpenReport "ReportName", acViewPreview, , "[ReportName].[DateRec]= #" & Me.[DateRec] & "#" But this doesn't work DoCmd.OpenReport "ReportName"...

I am trying to run a report from a Form Button based on two criteria; patient.ID and 1259rec (date) I can make it work based on the patient.ID but not the date (nor both) :confused: THIS WORKS Private Sub Command70_Click() DoCmd.OpenReport "CouponBk", acViewPreview, ...

This is about a Command Association with a button in a subform COMMAND DoCmd.OpenReport "AR", acViewPreview, , "[ar].[ltcfname]=" & Me.ltcfname.Value When I run the code I get the following error: Run-time error '3075': Syntax error (missing operator) in query expression...