Re: Out of my "Know How"
Tech-Archive recommends: Fix windows errors by optimizing your registry
The baic concept here, is for the Query to be set as the Record Source
of the report, and each field in the query needs to be represented by a
bound control (probably a textbox) on the report.
I am not sure what you are referring to with the "templete". Maybe it
would be better to create the basic report using the report wizard.
From the Reports tab in the Database Window, click New, then select
'Report Wizard', enter the name of the query in the 'Choose the table...
' box, and take it from there.
--
Steve Schapel, Microsoft Access MVP
Creating a report wrote:
I have the basic knowledge to create a database. The database I am currently
working on is a little out of my "know how"
I have a templete that I want to use for the report, I have all the
information in a table, I also have a query to pull the information I need
for the report. What do I do to combine the templete and my query.
I created the templete in forms and reports. Now I just need have the data
to filter in to the templete. I created both templete in the design view.
.
Relevant Pages
- Re: Populating a list -- table structure?
... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
(microsoft.public.access.forms) - Re: Fields in Label dont give correct information
... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
(microsoft.public.access.reports) - Re: Tips on domain aggregate replacements
... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
(microsoft.public.access.modulesdaovba) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) - Re: using a form with combo box to input criteria
... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
(microsoft.public.access.forms) |
|
