Re: Selections on Report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

So if I want it in a report. Do i just need a report based on the query? Or
do I still need to use the form in some way?

Allen Browne wrote:
Take a look at this example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

There's a downloadable example that shows how to make a search form like
that. The procedure is exactly the same for a report. The difference is that
instead of applying the Filter to the form, you use the filter strin in the
WhereCondition of OpenReport.

What I would like to do is be able to choose from a list of items before a
report is display. I know how to create a query and a report on a query.
However, how do I create a report that will allow be to select from a list
or
combo box so I don't have to remember the list.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200701/1

.

Relevant Pages

  • Re: Using only one record
    ... A fairly simple way to do this might be to create a search form in Continuous Form view. ... The button runs an OpenReport, filtering the report to the primary key of the current record. ... I have a query set ... it is very cumbersome in selecting the one record to use for the ...
    (microsoft.public.access.forms)
  • 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: Using only one record
    ... I would be entering a new customer ... query. ... an OpenReport, filtering the report to the primary key of the current ... Here's an example of how to make a search form: ...
    (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)