I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I知 trying to have a live MS Access report which would pull data from SQL Server. I値l try to explain how I知 trying do this:
The Access report should have two parts:
1. Title page report, just like table of contents. It should be listing a particular field of a view table and also should be filterable so that the title list would list only necessary report list.
Example:
[i]1. household information package<click to view or print>
2. small business information package<click to view or print>
3. medium business information package<click to view or print>
4. monthly seminar package<click to view or print>
2. Detail report: The detail report is for viewing the detail report or printing purpose which would be generated once we click on the report title hyperlink.
Example:
Title: 1. Household information package report
i. Kitchen
Description: bla bla bla bla
NameOfItem Cost Condition
ii. Living Room
Description: bla bla bla bla
NameOfItem Cost Condition
iii. Bed room
NameOfItem Cost Condition
My question is, How can I build the title page report with hyperlink or button next it. And, detail report which is launched/ printer when we click the link/button?
I知 sure I値l have more question but this is my first mountain to cross.
Thanks in advance for you help
Sonik