Re: Saving a Report Format

I am going on the assumption that you have a 2 field table with state names
in it and a state code or number. How do you want to select the state?
From a combo box (drop down list) or entering it?.
Either way the first 3 steps will be the same.

In your query you are using for the report do the following:
1) in an empty column select the table that contains the State field from
the drop down box in the Table row
2) select State from the drop down box in the Field row
3) select Where from the Totals row drop down box

To prompt for entering the state.
4) in the Criteria row type in [Enter State]
5) Open the Report in Design mode and type =[Enter State] as the
ControlSource for the State field.

When you run the report it will prompt to enter State and will produce a
report for that state.
------------------------------
If you are selecting from a Combo box.
4) in the Criteria row type in
=[Forms]![frmFormNameContainingComboBox]![cbxComboBoxName]![Enter State]
5) Open the Report in Design mode and select State as the ControlSource for
the State field.

Your query will use the State selected in the Combo box as the State for
sorting the records for your report.

I hope this isn't too complicated...if it is I can send you an example.

HTH
scruffy

"sebsings" wrote:

Thanks to both of you for getting back to me. Now I have a stupid question:
how exactly do I do what you have suggested? I wasn't sure how to get to the
info on Allen Brown's website. I think my best bet is to copy the report and
assign a new query to it, but how do I go about doing this? I've been
fiddling around with access and I'm not getting very far.
Thanks

"scruffy" wrote:

Since all the state reports will have identical formats you only need one
report which you have already completed. The only thing left to do is sort
the data that goes to the report.
There are several ways to accomplish this:

Common to ALL of these is to set the Record Source of the report to the
query that sorts the records.

- - You can set a field up in your query that prompts the user for the state
which will sort all those state records and set.

- - You can also build a filter and use it in the OnOpen event of the report
(a good example is on Allen Brown's website @ http://allenbrowne.com/tips.html

HTH
scuffy

"guido via AccessMonster.com" wrote:

If your subsequent queries have the same field names, you can copy the report
and assign the new query to it.

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

.

Relevant Pages

  • RE: Sorting in Query and Report involving look up combo box
    ... That is the problem with lookup fields. ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ... And, as I said before, Reports ignore the sort order of a query. ...
    (microsoft.public.access.reports)
  • RE: Sorting in Query and Report involving look up combo box
    ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ... how do you have your sorting and grouping set up in your report. ... And, as I said before, Reports ignore the sort order of a query. ...
    (microsoft.public.access.reports)
  • RE: Multiple sort query
    ... to sort by location, she would just select a person from the location drop ... then an employee from the drop down, and select run query. ... in turn run a report based on what was selected. ... list all employees they manage, a location report list all employees at that ...
    (microsoft.public.access.queries)
  • Re: Report Sorting
    ... "ricseb" wrote: ... Sort by "Collection Date". ... query that has all of the above fields, but am at a loss as to how to ... populate this report in the above order. ...
    (microsoft.public.access.reports)
  • RE: Separate Sort Order within same record
    ... If your report is not based upon a query then create one. ... Modify the query by opening in design view. ... Ascending or Descending in the Sort row remove the sort. ...
    (microsoft.public.access.reports)