how do I change tables with-in a report without starting over

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a report using a table but I forgot to arrange in ABC order. I went
back to the table and arranged it in ABC order but when I go back to the
report it's still not showing in abc order? Is there a way to delete the
table from the report and pull the table that is in ABC order without having
to redo the report again? Please say "yes"............
 
If you want to sort a report, use the sorting and grouping dialog from the
report design view.
 
Need said:
I created a report using a table but I forgot to arrange in ABC order. I went
back to the table and arranged it in ABC order but when I go back to the
report it's still not showing in abc order? Is there a way to delete the
table from the report and pull the table that is in ABC order without having
to redo the report again?
Click to expand...


It sounds like you might be suffering from a
misunderstanding.

You can not sort a table. You can only
sort the data returned by a query.

When you specify a sort while viewing a table's datasheet
view or specify a field in the table's OrderBy property, you
are only telling Access how you want the hidden query that
is used to display the table in sheet view to sort the
records (i.e when you Open the table from the database
window.

Futhermore, reports use their own internally generated query
(based on the report's record source) to retrieve the data
for the report. This means that the only reliable way to
sort the data in a report is to use the Sorting and Grouping
window. The Sorting and Grouping window is available by
using the View menu while the report is open in design view.
 
Thanks a lot it really helped. I was looking for a way and I can't believe it
was in front of my face all this time.

Now can you answer me this other question? Back to reports, if I use the
same design over and over again but have different tables to work with how
can I add the table to that design report without having too re-design it all
over again? Do you know what I mean?
 
I am afraid that I might know what you mean. Do you have several different
tables with basically the same structure? This is generally not a good
solution.
 
I use the database for mailings and since the letter is the same design we
have different locations where we mailed too. If there is an easier way to
pull another table from the current report design that would be great! If not
then I have no choice but to do it over again. Is that correct?
 
I haven't heard a justification that would prohibit the use of a single
table with a field to specify the "different locations".

Depending on the number of different location tables, you could create a
union query.

SELECT "Minneapolis" as Location, *
FROM tblMinneapolis
UNION ALL
SELECT "Eau Claire", *
FROM tblEauClaire
UNION ALL
SELECT "Willmar", *
FROM tblWillmar
.... etc ...
FROM tblEleva;

You can then base your report on the union query and filter it based on the
[Location] field.
 
Back
Top