DataBase - Can I add a map to an Access report?

I'd like to create a prospect sheet for salesmen with a business address,
other info  and a printed map from Yahoo, Google, or Bing so they can easily
find their next location. Can I do this through an Access report using a
control object or ActiveX object? If so, what is the object and how is it
used?

  Rob Parker replied to ProgrammerViejo

Article 193 on this page might be useful:
http://www.helenfeddema.com/access.htm

it is about Google maps on a form, where they are interactive, rather than a
report; but it might give you a starting point.

HTH,

Rob

DataBase Count and Filter Result My report has = Count(*) in the group header and I want to filter the results. Report Example: IDnumber Group Header Total of Reports Last Name First Name Idnumber 2 Smith Joe total of 4 or more. Try this in the query used as source for the report - -- SELECT [Last Name], [First Name], [Idnumber], Count([Idnumber]) AS [Total of Reports] FROM YourTable WHERE current code for my query. Where would I put the below infromation? SELECT [Minor Disciplinary Report].Last, [Minor Disciplinary Report].First, [Minor Disciplinary Report].IDnumber, [Minor Disciplinary Report].Unit, [Minor Disciplinary Report].Dateofreport, [Minor Disciplinary Report].[Gpsanction 1], [Minor Disciplinary Report].[Asddsanctions 1], [Minor Disciplinary Report].[Ccusanctions

over three weeks to find the solution to this problem: the Ending Balance of a report with two subreports. I have the Beginning Balance and the two subreports in the Detail Section of the Main Report: rpt_AFinancialStmt. I know that I have to add the beginning balance, the total income together I received a post from Duane stating I needed to have the name of the report and “txtIncomeSum” or “txtExpenseSum” as the Control Source in an unbound text box Ending Balance. Not fully understanding your post, “If the subreport is in the main report's detail section, then you need to calculate the total from all instances of the box named txtRunAmt to the detail section. Set its control source expression to: = IIf(QRYsubrptInvoice.REPORT!HasData, QRYsubrptInvoice.REPORT!idamt, 0) and set its RunningSum property to Over All. Then the grand total in the main report's footer would use the expression: = Sum(amt) + txtRunAmt “ Since I’d tried I put an unbound txt box with the control source of “ = IIf(SubRpt_AInc.Report!HasData, SubRpt_AInc.Report!idamt, 0) and set the running sum to all over. And try

DataBase Weighted Calculations I am trying to total an aggregate function in a report. Here is the basics. UnitIn- UnitOut - Yield - WtYield 10100 - 10000 - 99.01% - 90.01% 2000 UnitOut / sum([UnitOut]) = sum([WtYield]) does not work. These calculations are taking place in a report. I tried to make it happen in a query, but due to the group by to show all the proper fields (not shown here in interest of brevity) for the report it does not sum up the LBSProd properly. Is there a way to remove the Group By in the query, and still have the data show in a report perhaps? Any ideas? Post the SQL of your query as you have it now. Open all, copy, and paste in a post. - - Build a little, test a little. SELECT [Prod Report Master Data].Date, [Prod Report Master Data].[ITEM No], [Prod Report Master Data].Brand, [Prod Report Master Data].Description, [Prod Report Master Data].[Line#], [Prod Report Master Data].[CS PRODUCED], [Prod

have created a database to do our reports. One of our reports is an operations report that could have supplemental reports and use of force reports "attached" to it through an autonumber. If officers fill out a supplemental report, they can also have a use of force attached to the supplemental report. All is working and I can print each report separately. I want to create a function that will allow me to print all reports attached to the main operations report, to include the proper page header / footer for each report (as operations / supplemental reports can be multiple pages per report). Problem: I have an 'AutoNum' field for each report, and the supplemental and use of force have an 'AutoFromOR' fields that point back to