Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

working with Reports

Status
Not open for further replies.

dafi

Programmer
Apr 19, 2001
25
RO
I want to know if there is any way to create iinteractive-reports without using an existing report.
What I mean:
I have multiple tables into an .mdb with are corelated.
I want to let the user to create his own reports depending on what he needs.
The .mdb contains a structure that hold an football (soccer) championship. So I have teams, players, matches, goals , yellow and red cards, changes, etc.
One example of a query is
show me all the players that have at least 5 goals and no red cards for the teams which are in the promotion part of the table.
or
list all the yellow cards that have been "awarded" in the last week.

There are multitude of possibilities and my tables can hold them, but I don't know how to make them accesible to the user in an user-friendly form (for printing or previewing).

I look forward for your responses.
yOurs trully, dafi
 
All u need is to use a querry witch is created interactively by the user choises and then use the recordset to show the records ________
George, M
 
I'm using vb simply.
I know I can use build in reports, and I know that I can create queries almost interactive.
How do I make a record set record become a ready-to-print, well-organised page, including printer choosing and so on ?
 
am observat o chestie interesanta cu easy.ro
cred ca putem sa ne intelegem mai usor ...
o sa ma uit pe chestia aia
Merci.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top