Reports

Import a PDF File into an Access 2007 Report
How can I import a PDF file to show up on an Access 2007 Report I'm trying to create. If I have to convert to a .JPEG file can you tell me how to do this please? Thanks -- Alison ... 3 May 2010 10:57

Calculate 30 minutes earlier
Can you show me how to calculate a short time, i.e., 13:35, so that the result is 30 minute earlier; so it should show 13:05? Another example is: 13:05, the field on the report will show 12:35. Thanks! ... 30 Apr 2010 02:56

Create Report using fields from Form's datasheet
I have a form in datasheet view and I have a control that allows me to view and hide various fields. I would like to be able to click a button to create a report for printing using the fields that are visible on the datasheet. I don't need to be able to save the report for later use. I'd like it to open the ... 28 Apr 2010 00:39

Rerun query
I have a report based on a query. On opening the report you are prompted to enter 3 parameters (start date, end date, employee name). I need to run a seperate report for each employee. Is there anyway to code or create a macro that tells the report to reopen with new parameters upon closing or printing. I a... 27 Apr 2010 15:40

Subreport link by Date field
Hello, I have an Access 2003 report with a subreport. The main report has a column for customerID and Date, I want the subreport to show any records from another table that occurs after the Date on the main record. Can I use the Link Child Field and Link Master Field for this? I know I can put "CustomerID;Da... 27 Apr 2010 15:40

Report exporting different data from what is on the report
I have a standard Access 2007 report (based on a query) in my database that pulls information on a specific item. The report runs fine but when the user right clicks on the report and exports to Excel, they get the information for a different item. I had them delete the export file and try renaming it. Neith... 29 Apr 2010 14:41

Report with buttons to open forms
Al, I need to be able to rank order these records each time the query is run as the order may change throughout the day as users call up the form. -- Donna N. "Al Campagna" wrote: Donna, Why do you need to sequentially number your records? If it's used to identify a particular record... 27 Apr 2010 11:03

Rounding Averages on my Report
I created a summary report using the report wizard and grouped by date and selected avg. The report works fine except I would the numbers to be rounded. For example: The average for January shows 19.5, however I would like it displayed as 20. If February is 23.1678993, I would like it displayed as 23. Ca... 28 Apr 2010 01:48

Group totals in dynamic report
I have a report that dynamically gets control source for five columns based on user input through a form. The report successfully shows text boxes (currency format) with approporiate fields (control source) and respective data. I then have unbound text boxes for each of the five columns to show group totals. I ... 26 Apr 2010 23:58

Criteria from form on report
If you have an unbound form that you use for criteria and you want your report to display the criteria selected by the user in the page header, how would you do that? Thanks for any suggestions. ... 26 Apr 2010 17:14